SELECT
FirstName,
LastName,
[Row Number]=ROW_NUMBER() OVER(ORDER BY SalesYTD DESC), SalesYTD
FROM x
Showing posts with label SQL: Row Number Example. Show all posts
Showing posts with label SQL: Row Number Example. Show all posts
Tuesday, 22 September 2009
Subscribe to:
Posts (Atom)