group having

最新推荐文章于 2025-07-03 13:46:19 发布

xss23into

最新推荐文章于 2025-07-03 13:46:19 发布

阅读量110

点赞数

分类专栏： java

java 专栏收录该内容

11 篇文章

订阅专栏

SELECT count(*) AS tp_count FROM `tg_question` WHERE quid=0 LIMIT 1 

SELECT fid,fuid,ftitle,fstatus,fcount,count(d.did) as discuss FROM `tg_feed` 
LEFT JOIN tg_discuss as d on d.dpid=fid and fuid=0 GROUP BY fid ORDER BY fid desc LIMIT 0,10;

SELECT fid,fuid,ftitle,fstatus,fcount,count(d.did) as discuss FROM `tg_feed` 
LEFT JOIN tg_discuss as d on d.dpid=fid GROUP BY fid having fuid=0 ORDER BY fid desc LIMIT 0,10;

SELECT qid,quid,qtitle,qstatus,qclickcount,count(a.aqid) as answer FROM `tg_question` 
LEFT JOIN tg_answer as a on a.aqid=qid GROUP BY qid HAVING quid=0 ORDER BY qid desc LIMIT 0,10 ;


select qa.*,b.acontent as content from tg_answer b,(select a.*,q.bestaid,q.qtitle
from tg_answer a,tg_question q where aqid=q.qid and aid=1) qa 
where b.aid = qa.bestaid