Aggregate function in SQL WHERE-Clause

by

HAVING is like WHERE with aggregate functions, or you could use a subquery.

select EmployeeId, sum(amount)
from Sales
group by Employee
having sum(amount) > 20000

Or

select EmployeeId, sum(amount)
from Sales
group by Employee
where EmployeeId in (
    select max(EmployeeId) from Employees)

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Count with out using a joins
  3. Making a dynamic pivot table but without using the fiddle
  4. Get top 1 row of each group
  5. Entity Attribute Value Database vs. strict Relational Model Ecommerce
  6. Convert Datetime column from UTC to local time in select statement
  7. Why is SQL Server losing a millisecond?
  8. Spark SQL window function with complex condition
  9. How do I split a delimited string so I can access individual items?
  10. Common Table Expression, why semicolon?
  11. T-SQL split string based on delimiter
  12. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  13. Why use Select Top 100 Percent?
  14. How do I find duplicates across multiple columns?
  15. Select data from date range between two dates
  16. When can I save JSON or XML data in an SQL Table
  17. Query comparing dates in SQL
  18. SQL Server silently truncates varchar’s in stored procedures
  19. Mysql: how to select groups having certain values?
  20. Return setof record (virtual table) from function
  21. OVER clause in Oracle
  22. PARTITION BY with and without KEEP in Oracle
  23. sqlite equivalent of row_number() over ( partition by …?
  24. Stored procedure that exports data into csv files only exports to one file
  25. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  26. Using LIKE in an Oracle IN clause
  27. SQL distinct for 2 fields in a database
  28. Select rows with same id but different value in another column
  29. Use one CTE many times
  30. How to store a list in a db column

Leave a Comment