原文:http://duzou.tk/archives/52.html
一个SQL分页代码:
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY 排序 ASC) AS rowNum, * FROM DicValue_Name WHERE ID IN(6)) AS t WHERE rowNum > star AND rowNum <= end;
注:
排序:排序字段
DicValue_Name:表名
ID:分页附加条件
star:该页第一条数据 star = (page – 1) * row
end:该页最后一条数据 end = page * row