having and group by clause in sql code example

Example 1: sql group by example

SELECT column_name(s)
  FROM table_name
  WHERE condition
  GROUP BY column_name(s)
  HAVING condition
  ORDER BY column_name(s);

Example 2: group by in sql

GROUP BY: is used to collaborate
with the SELECT statement to arrange 
matching data into groups.

ORDER BY: is for sorting result
either in descending or ascending order.

Tags:

Sql Example

Related