SQL Server Insert Row number in Query Resultset

Select Like following

SELECT custid, custname, ROW_NUMBER() OVER(ORDER BY custid asc) AS ‘Row Number’ from members

will list row number serially

  • Share/Bookmark