select ID,reg_username,reg_pwd from reg_user where ID<(select min(ID) from
(select ID from reg_user order by ID desc where rownum < 7) as c) and (rownum < 7) order by ID desc
(select ID from reg_user order by ID desc where rownum < 7) as c) and (rownum < 7) order by ID desc
(select ID from reg_user order by ID desc where rownum<7) order by ID descoracle中没有top
sqlserver select top n col from tabl
相当于oracle中的 select col from tabl where rownum<=n
那我想改成在mysql里能用,怎么改呀?
(select top 6 ID from reg_user order by ID desc) as c) order by ID descselect id,reg_username,reg_pwd from
(
select id,reg_username,reg_pwd,row_number() over (order by id desc) rownumid from reg_user where id < (select min(id) from (select id,row_number() over (order by id desc) from reg_user where rownum <=6))
and rownum <=6
) order by rownumid