在mysql中采用:
select * from table user where userid limit 0,n
//这里limit 后面的数相当于rowid,不是id
在oracle中采用:
select * from
(select u.*,rownum rn from (select * from user_)u where rownum<6)
where rn>1
在mysql中采用:
select * from table user where userid limit 0,n
//这里limit 后面的数相当于rowid,不是id
在oracle中采用:
select * from
(select u.*,rownum rn from (select * from user_)u where rownum<6)
where rn>1