 |
| |
Ms SQL Server COUNT แบบหลายเงื่อนไข แต่ GROUP BY ดันไม่ยอมแบ่งกลุ่มให้ help me please !!! |
| |
 |
|
|
 |
 |
|
แก้ไปแก้มาแบ่งกลุ่มได้แล้ว แต่ ค่า SummoneyBath1 ดันแสดงผล เหมือน CountProject1 TT
Code (SQL)
SELECT strategyID,
COUNT(P.projectID) AS CountProjecttotal,
COUNT(case when projectState = 1 then 1 else null end) as CountProject1,
COUNT(case when projectState = 2 then 1 else null end) as CountProject2,
COUNT(case when projectState = 3 then 1 else null end) as CountProject3,
SUM(P.moneyBath ) AS SummoneyBathtotal,
SUM(case when projectState = 1 then 1 else null end) as SummoneyBath1,
SUM(T.disbursed) AS Sumdisbursed
FROM project AS P
LEFT OUTER JOIN project_trace AS T ON (P.projectID = T.projectID)
WHERE moneyYearSupport = @moneyYearSupport
GROUP BY strategyID
|
 |
 |
 |
 |
| Date :
2014-03-08 14:50:46 |
By :
ต้น |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ได้แล้ว เหอๆ
Code (SQL)
SELECT strategyID,
COUNT(P.projectID) AS CountProjecttotal,
COUNT(case when projectState = 1 then P.projectID else null end) as CountProject1,
COUNT(case when projectState = 2 then P.projectID else null end) as CountProject2,
COUNT(case when projectState = 3 then P.projectID else null end) as CountProject3,
SUM(moneyBath ) AS SummoneyBathtotal,
SUM(case when projectState = 1 then moneyBath else null end) as SummoneyBath1,
SUM(T.disbursed) AS Sumdisbursed
FROM project AS P
LEFT OUTER JOIN project_trace AS T ON (P.projectID = T.projectID)
WHERE moneyYearSupport = @moneyYearSupport
GROUP BY strategyID
|
| |
|
|
| |
| Date :
2014-03-08 15:03:38 |
By :
ต้น |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
