HOME

Saturday, February 5, 2011

ROW NUMBER in SQL SERVER 2005

SELECT EMPID, row_number() over (order by EMPID) Sno FROM EMPLOYEE
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)