|
转载自传智播客论坛
sql server方案1：
select top 10 * from t where id not in (select top 30 id from t order by id ) orde by id sql server方案2： select top 10 * from t where id in (select top 40 id from t order by id) order by id desc mysql方案：
select * from t order by id limit 30,10
oracle方案：
select * from (select rownum r,* from t where r<=40) where r>30
其实 这只是我们知道的！对于oracle 还有一个抓取
|
扫一扫
03-27
504
504
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
