I think what you may be looking for is the keyword
HAVING
. It's a bit like a
WHERE
clause but it applies to the grouped data:
SELECT [columns]
FROM [tables]
WHERE [clauses]
GROUP BY [non-aggregates]
HAVING [aggregate clauses]
or maybe even isnull could help.
SELECT Constituency,
SUM(CASE WHEN [IT-ITES1] = 'Approved' THEN ISNULL([IT-ITES],0) ELSE 0 END)
FROM Capacity
group by Constituency
having SUM(CASE WHEN [IT-ITES1] = 'Approved' THEN ISNULL([IT-ITES],0) ELSE 0 END) > 0
and SUM(CASE WHEN [IT-ITES1] = 'Approved' THEN ISNULL([IT-ITES],0) ELSE 0 END) IS NOT NULL
This will eliminate any Constituency that doesn't have a value
Alternatively, You may just want to eliminate any other Constituency is the standard Where clause:
SELECT Constituency,
SUM(CASE WHEN [IT-ITES1] = 'Approved' THEN ISNULL([IT-ITES],0) ELSE 0 END)
FROM Capacity
WHERE Constituency = 'Adilabad'
group by Constituency