Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Friday, May 14, 2010
SQL: How to display row count / row number
select ROW_NUMBER() OVER(ORDER BY ID,Name) AS 'Num', ID,Name
Subscribe to:
Posts (Atom)