CODEWITHSUNDEEP
sqlt-sqlsql-server-2016
user6038265
user6038265

Reputation:

How can I filter a group-by query by an aggregate function ?

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

Answers (1)

user9148986
user9148986

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

Related Questions