mysql的關聯查詢求和？
參考sql語句
select
sum(casewhena1=1then1else0end)asa1count,
sum(casewhena2=1then1else0end)asa2count,
sum(casewhena3=1then1else0end)asa3count,
sum(casewhena4=1then1else0end)asa4count
from表
網站導航
- zblogPHP模板zbpkf
- zblog免費模板zblogfree
- zblog模板學習zblogxuexi
- zblogPHP仿站zbpfang