MysqL 转Oracle的问题

Question

select
id,cardno,mt.cardname,saler,storedate,money,moneytype,remaincount,opuser,opertime,selldate,username from
membercard mc
left join pt_user on userno=saler
left join membertype mt on mc.cardtypeid=mt.cardtypeid

order by mc.id desc limit 0,22
转成Oracle语法，应该是怎样呢？

Answer 1

如果仅针对本题目
select
id,cardno,mt.cardname,saler,storedate,money,
moneytype,remaincount,opuser,opertime,selldate,username
from membercard mc
left join pt_user on userno=saler
left join membertype mt on mc.cardtypeid=mt.cardtypeid

where rownum<=22
order by mc.id desc

如果分页
select * from (select m.*,rownum as rn from (
select
id,cardno,mt.cardname,saler,storedate,money,
moneytype,remaincount,opuser,opertime,selldate,username
from membercard mc
left join pt_user on userno=saler
left join membertype mt on mc.cardtypeid=mt.cardtypeid

) m ) where rn between a and b;

其中 a,b为起止游标，入2,10，即第二条到第10条记录，区别于mysql的limit参数