Friday, May 14, 2010

SQL: How to display row count / row number

select  ROW_NUMBER() OVER(ORDER BY ID,Name) AS 'Num', ID,Name

No comments: