Which clause filters groups after aggregation?

SQL Data Analyst Easy

SQL Data Analyst — Easy

Which clause filters groups after aggregation?

Key points

  • HAVING filters groups after aggregation
  • WHERE filters rows before grouping
  • GROUP BY organizes data into groups
  • FILTER is not a standard SQL clause
  • HAVING is used with GROUP BY for group-level conditions

Ready to go further?

Related questions