SQL Select With Group By Statement


Groups results

Syntax

SELECT select_columns FROM table_name [GROUP BY column_name]
column_name:   column to group by

Example


select * from persons where age < 50 group by age