Select sum for filed with all value is 1 results different with number or rows

Asked Mar 03 '22 at 05:21

Active Mar 03 '22 at 05:45

Viewed 59 times

This is my query :

SELECT DISTINCT murid.ID,  
CASE WHEN ..... AS Jumlah
FROM murid
JOIN ... 
JOIN ...
WHERE ....

It results 15 rows with 'Jumlah' has all value is '1'.

When I add sum for Jumlah like this...

SELECT DISTINCT murid.ID,... 
SUM(CASE WHEN ..... ) AS Jumlah
FROM murid
JOIN ... 
JOIN ...
WHERE ....

It results Jumlah with value 28. I only add sum but it result different value.

This value of '28' seems number of rows when I remove DISTINCT.

Somebody please help me, thanks

edited Mar 03 '22 at 05:34

Akina

asked Mar 03 '22 at 05:21

jauhari tontowi

Remove DISTINCT in 1st query. – Akina Mar 03 '22 at 05:35
When i remove distinct in first query it result 28 rows, but it contains some rows with same ID, i need unique ID, and it should results 15 rows – jauhari tontowi Mar 03 '22 at 05:42
close by this solution : https://stackoverflow.com/questions/18218108/trying-to-sum-distinct-values-sql – jauhari tontowi Mar 07 '22 at 05:09

0 Answers0