Question

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

1:自己要先测试通过再把答案贴上来。2:注意一下性能。

Answer 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