利用rownumber函数进行查询
select * from (select ROW_NUMBER() OVER(Order by ID desc) as rowin, * from tbDiamond where AddDateTime>='2015-01-12')a where rowin>=50 and rowin<=100SQL 排序后取表中间的几行数据
最新推荐文章于 2021-11-30 12:02:49 发布
利用rownumber函数进行查询
select * from (select ROW_NUMBER() OVER(Order by ID desc) as rowin, * from tbDiamond where AddDateTime>='2015-01-12')a where rowin>=50 and rowin<=100