![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
杏杏杏
願意交朋友喜歡交朋友
很樂意幫助每一個人^-^
展开
-
mysql分组查询并只显示每组数据的前N条数据
這需要用到自連接查詢也就是自己連接自己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_datetimegroup by根據id和時間分組查詢HAVING COUN原创 2016-12-18 14:52:34 · 5839 阅读 · 0 评论 -
[Err] 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
mysql原创 2016-12-17 15:21:51 · 2135 阅读 · 0 评论