All geek questions in one place

How to filter a group query using an aggregate function?

How can I only show results with 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
+5
source share
1 answer

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
+7
source

Source: https://habr.com/ru/post/1274369/

More articles:


All Articles