Elijah

摘要： 面试必考题，不过还是linq好使！方法1：SELECT TOP 页大小 *FROM table1WHERE id NOT IN ( SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id )ORDER BY id方法2：SELECT TOP 页大小 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1 )WHERE RowNumber > 页大小*(页数-1) 阅读全文