表连接和分组数目查询
查询查询此表中library_id=6的以topic_id和topic_name为一组的数量SELECT topic_id AS topicid,topic_name AS topicname,COUNT(*) AS num FROM `comment` WHERE library_id = 6 GROUP BY topic_id,topic_name; 关于两个表的连接查询表一表二让表一的modu
原创
2016-09-21 17:38:37 ·
264 阅读 ·
0 评论