做成存储过程,传入页码,计算分页显示的记录数即可
SELECT x.*
FROM (
SELECT table.*,
ROW_NUMBER() OVER ( ORDER BY Day_Id ) dr
FROM table
WHERE table.Date BETWEEN '2008-01-01' AND '2008-01-31'
) x
WHERE dr BETWEEN 1 AND 10