Tuesday, October 12, 2010

How to count rows in a coloum

SELECT ROW_NUMBER () OVER (ORDER BY date) AS Rowid
FROM tblattendance

No comments:

Post a Comment