使用mysql或oracle获取10到20之间的记录

Mysql：select * from limit 9,10

Oracle: SELECT  b.* FROM

-- 第二层给定行号

(SELECT rownum r,a.* FROM )

-- 第一层 进行排序

(SELECT  t.* bos_t_user t ORDER BY user_id DESC)

a

WHERE b.r<=20

)

b WHERE b.r BETWEEN 10 AND 20  from (select rownum as num,id,test1,test2 from databasetest a where rownum < 20)
where num > 11;

Sqlserver：select top 10 * from pub_Resource where ResourceName not in (select top 10 ResourceName from pub_Resource);