mysql limit 后子查询_Mysql子查询用limit
执行带有Limit子查询是有问题的：
SELECT * FROM
task_and_device
WHERE
job_id IN
(SELECT
id
FROM wx_device_task_job
WHERE
user_id=79269 AND STATUS=1
ORDER BY last_updated DESC
LIMIT 20 OFFSET 0)
报了如下的错误：
错误码: 1235
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
需要再加上一层select才能成功：
SELECT * FROM task_and_device WHERE job_id IN
(
SELECT A.id FROM
(
SELECT id FROM wx_device_task_job WHERE user_id=79269 AND STATUS=1 ORDER BY last_updated DESC
LIMIT 20 OFFSET 0
) AS A
)