7.3. Having clause

 

  • The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.

QUERY: - SELECT column_name(s) FROM table_name GROUP BY column_name(s) HAVING condition ORDER BY column_name(s);

EXAMPLE: - SELECT COUNT (CustomerID), Country FROM Customers GROUP BY Country HAVING COUNT (CustomerID) > 5;

Last modified: Monday, 2 December 2019, 12:18 PM