Reputation:
How can I only display results which have a budget > 1000 ?
SELECT
BP_Year
,BP_UID
,BP_Name
,SUM(BP_Budget) as sumBudget
FROM T_UPS_BudgetPositions
GROUP BY
BP_UID
,BP_Name
,BP_Year
Upvotes: 2
Views: 63
Reputation:
By using the HAVING-clause:
SELECT
BP_Year
,BP_UID
,BP_Name
,SUM(BP_Budget) as sumBudget
FROM T_UPS_BudgetPositions
GROUP BY
BP_UID
,BP_Name
,BP_Year
HAVING SUM(BP_Budget) > 1000
Upvotes: 4