有 ask 问题表和 answer回答表回答表中的ask_id和 ask表中的id对应 1、查询
/*
查询回答了的好歌听不够
氧化铬
*/
select a.id,a.title,count(b.ask_id) as num from phome_ecms_ask a,phome_ecms_answer b where a.id=b.ask_id group by a.id order by num desc
掌声高军
高平黑猪2、将ask问题表中的问题按回答数量排序手推车 艾青
/*
查询所有的问题按回答数排序
*/
都市乡下人
select a.id,a.title,count(b.ask_id) as num from phome_ecms_ask a left join phome_ecms_answer b on a.id=b.ask_id group by a.id order by num desc