SQL分页语句

SELECT TOP 页大小 *FROM Users WHERE (ID NOT IN (SELECT TOP (页大小*(页数-1)) ID FROM Users ORDER BY [NoteID] DESC))ORDER BY ID DESC
posted @ 2009-03-19 16:05  YaSin  阅读(102)  评论(0)    收藏  举报