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一起出現