Sharing knowledge in Project Portfolio Innovation Management (PPIM) and various Technology.
Thursday, April 17, 2008
Paging In Sqlserver 2005
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY person) AS rownum, person, income FROM Salaries) AS Salaries1 WHERE rownum >= 5 AND rownum <= 9 ORDER BY income
