mysql语句怎么写limit相关的

[qukmei]

在sqlserver里，这样一句是可以：
select top 6 ID,reg_username,reg_pwd from reg_user where ID<(select min(ID) from
(select top 6 ID from reg_user order by ID desc) as c) order by ID desc


我想在mysql里也实现这样的一句，请问怎么样实现　呀，我是这样的写的，但是不对

select * from userinfo where user_id<(select min(user_id) from (select * from userinfo order by user_id desc limit 2) as c) order by user_id desc limit 2;

[qukmei]

那用mysql如何实现我那个sql语句的功能呀？哪怕是分开写如何做呀？

[qukmei]

晕，怎么没有呀？

[zse3]

MYSQL不支持中间表，即FROM后不能为内存表。MS SQL可以

[qukmei]

顶一下，还是不知道呀