For details on the ROW_NUMBER() function and its use, see:
http://msdn2.microsoft.com/en-us/library/ms186734.aspx
For info on other ranking functions in SQL Server 2005, see:
http://msdn2.microsoft.com/en-us/library/ms189798.aspx
source : http://blogs.msdn.com/b/sqlserver/archive/2006/10/25/limit-in-sql-server.aspx
Tidak ada komentar:
Posting Komentar