分页SQL代码

weixin_34161029

于 2014-08-13 10:08:00 发布

阅读量66

点赞数

本文将展示如何使用SQL语句筛选特定国家和父级ID下的城市信息，并通过子查询和窗口函数进一步限制查询结果为特定范围内的城市ID。

SELECT TOP 10 * FROM citys WHERE (city_id NOT IN (SELECT TOP 30 city_id FROM citys where country_id=44 and parent_id=0 ORDER BY city_id)) and  country_id=44 and parent_id=0 ORDER BY city_id

select * from (select *,ROW_NUMBER() OVER(Order by a.city_id) AS RowNumber from citys as a where country_id=44 and parent_id=0 ) as b where RowNumber BETWEEN 20 and 30