错误:刚开始想用top来实现发现获取的分页数据是排序之前的,所以只能想其他办法了
实现:使用SELECT ROW_NUMBER() OVER (ORDER BY t.show_count)AS Row,t.* from 来实现
SELECT * from (SELECT *,row=row_number() OVER(ORDER BY timestamp DESC) FROM znzs_log)
as a WHERE row BETWEEN 1 and 10
错误:刚开始想用top来实现发现获取的分页数据是排序之前的,所以只能想其他办法了
实现:使用SELECT ROW_NUMBER() OVER (ORDER BY t.show_count)AS Row,t.* from 来实现
SELECT * from (SELECT *,row=row_number() OVER(ORDER BY timestamp DESC) FROM znzs_log)
as a WHERE row BETWEEN 1 and 10