看过此博文后Oracle、MySql、SQLServer 数据分页查询,在根据公司的RegionRes表格做出了
SQLserver的分页查询语句:
SELECT DISTINCT TOP 500
别名.字段
FROM(
SELECT row_number() OVER (ORDER BY oo.ID ASC) AS rownumber,
* FROM(SELECT DISTINCT * FROM 表 o WHERE 字段 = 0 ) AS oo
) AS 别名
WHERE rownumber > 10;
MySQL的分页查询语句:
SELECT DISTINCT *FROM 表
WHERE 字段1 = 0 ORDER BY ID ASC LIMIT 10,500
其他网站: