求mysql查询语句 按照文章评论数量的多少排序输出文章列表 评论数量多的最先输出a表 是文章表 字段 a_id,a_title,a_textb表是评论表字段 b_id,b_pid(存储a表的id,也就是评论所属的文章id),b_comment求能够实现改功能的mysql查询语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT a.id, a.titleFROM a, bWHERE a.id = b.p_idGROUP BY a.id, a.titleORDER BY sum( b.id ) descLIMIT 0 , 30 字段对应着看看吧,可能和你的有些区别。 不能编辑,只能连续回复了。SELECT a.id, a.title,count( b.id ) FROM a, bWHERE a.id = b.p_idGROUP BY a.id, a.titleORDER BY count( b.id ) DESC LIMIT 0 , 30 SELECT a_id, a_title ,COUNT(b_id) AS ncount,FROM b LEFT JOIN a ON a.a_id = b.b_pidGROUP BY b.b_pidORDER BY ncount desc SELECT count( b.p_id ) pcount, a.a_id,a.a_title,a.a_text FROM a, b WHERE a.a_id= b.b_pid GROUP BY a_id HAVING count( a.a_id ) >=0 ORDER BY pcount DESC select a.a_id,a.a_title,count(b.b_pid) as b_countfrom b left join a on b.b_pid=a.a_idgroub by b_pidorder by b_count desclimit 0,30; SELECT count( b.p_id ) pcount, a.a_id,a.a_title,a.a_text FROM a, b WHERE a.a_id= b.b_pid GROUP BY a_id ORDER BY pcount DESC select a.a_id,a.a_title,count(b.b_pid) as b_count from b left join a on b.b_pid=a.a_id group by b_pid order by b_count desc limit 0,30; 各位老大给看下 这段代码 怎么修改 效率更高 求解正则匹配HTML标签 cookie的expire时间戳? !DOCTYPE的问题请教 网站之路要模糊吗? phpstorm如何开启sql函数提示 關於PHP從WINDOWS平台上移到linux下面(在線等) 因为事情很急,水平太差,不得不在问大家:如何一行一行的读出TXT文件,并且分别读出每一行用逗号阁开的字符 php在一个页面如何实现同时读取两个数据库,并从这一个表中提取内容存到另一个数据库中。 什么情况下用到redis数据库?什么样的数据库适合放在redis里尼? DOM读取XML php调用activex的问题
FROM a, b
WHERE a.id = b.p_id
GROUP BY a.id, a.title
ORDER BY sum( b.id ) desc
LIMIT 0 , 30
字段对应着看看吧,可能和你的有些区别。
FROM a, b
WHERE a.id = b.p_id
GROUP BY a.id, a.title
ORDER BY count( b.id ) DESC
LIMIT 0 , 30
FROM b LEFT JOIN a ON a.a_id = b.b_pid
GROUP BY b.b_pid
ORDER BY ncount desc
FROM a, b
WHERE a.a_id= b.b_pid
GROUP BY a_id
HAVING count( a.a_id ) >=0
ORDER BY pcount DESC
from b left join a on b.b_pid=a.a_id
groub by b_pid
order by b_count desc
limit 0,30;
FROM a, b
WHERE a.a_id= b.b_pid
GROUP BY a_id
ORDER BY pcount DESC
from b left join a on b.b_pid=a.a_id
group by b_pid
order by b_count desc
limit 0,30;