Tuesday, 22 September 2009

SQL: Row Number Example

SELECT
FirstName,
LastName,
[Row Number]=ROW_NUMBER() OVER(ORDER BY SalesYTD DESC), SalesYTD
FROM x
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)