當(dāng)前位置：首頁(yè) > IT技術(shù) > 數(shù)據(jù)庫(kù) > 正文

mysql里面的count函數(shù)連表查詢某個(gè)字段在另一張表的數(shù)量
2022-05-29 22:33:48

select c.*,
(select count(hcus.id) from  hcus where c.id=hcus.id and study_status='finished') as learnStuNum,
(select count(hcus.id) from  hcus where c.id=id ) as learnNum
from  c
where c.id=#{id}

本文摘自 ：https://www.cnblogs.com/

開(kāi)通會(huì)員，享受整站包年服務(wù)立即開(kāi)通 >
推薦內(nèi)容