Question

mysql取前几条 SELECT * FROM users where userId not in (SELECT userId from users limit 0,3) LIMIT 3;

[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
去掉limit 0,3 就能执行。我想查询users表中的排除前三条的前三条记录，帮忙解决！

Answer 1

SELECT top 3 * FROM users where userid in (select top 6 userId from user ) order by userid desc

Answer 2

select top 3 * from tsmordermanage where id not in (select top 3 id from tsmordermanage)

Answer 3

SELECT * FROM users LIMIT 3,3;