[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

mysql in查詢和limit不能同時用

in(job.sfj_datatime,10) jobdate 
 from bbjobcourse job group by job.sfj_datatime order by jobdate desc limit 2)這是我原來的sql報錯了後來改爲

in (
select left(job.sfj_datatime,10) jobdate from (select sfj_datatime 
 from bbjobcourse group by sfj_datatime order by sfj_datatime desc limit 2)job)在外面再套一個查詢就好了避免in和limit一起出現