无视这种命令式的提问,又没领你工资有道歉,算了。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