求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; 没有fopen权限,可以用别的方法下载远程文件么? 求教:使用 $word = new COM("word.application")后用对象调用的方法在哪里有介绍 PHP session.auto_start Lost session varible between pages php转向问题 while循环结果集内,执行了一个正确的sql,while循环即被终止,不知道什么原因,求大虾 急求eWebeditor 2.8.0 php版本 急求替换html标签的正则表达式 高手呢,高手,高手在哪里? 怎么与ACCESS连接 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;