Geeks With Blogs
| Home |

Try this:

use Northwind
select (select SUM(1) from Region where RegionID <= reg.RegionID) as 'Row Number', * from Region reg

Posted on Wednesday, January 26, 2005 10:09 AM | Back to top


Comments on this post: Simple SQL Row Number

No comments posted yet.
Your comment:
 (will show your gravatar)
 


Copyright © | Powered by: GeeksWithBlogs.net | Join free