Showing posts with label get counts. Show all posts
Showing posts with label get counts. Show all posts

19 September 2011

get the serial no. for records of table in sqlserver

select empname, row_number() over(order by empid)as 's.no' from tblEmp