杏杏杏妹子的博客

這需要用到自連接查詢也就是自己連接自己 select * from bbjobcourse a inner join bbjobcourse b where a.ct_id=b.ct_id and a.z_datetimeb.z_datetime 則出來時間的倒序  group by a.ct_id,a.z_datetime group by根據id和時間分組查詢 HAVING COUN

mysql