写sql语句,完成查询表中第10条到第20条记录?

1:自己要先测试通过再把答案贴上来。2:注意一下性能。
2024-11-29 21:41:37
推荐回答(1个)
回答1:

无视这种命令式的提问,又没领你工资

有道歉,算了。

sql server:select a.* from (select top 20 * from 表) as a where a.id not in (select top 9 b.id from 表 as b)

oracle:select * from (select rownum rn,a.* from fnd_user a where rownum < 21) where rn > 9