Syntax

SELECT col_1, max(col_2) FROM table

GROUP BY col_1

• column in GROUP BY must be in SELECT list

• There can be multiple columns in GROUP BY. Where their list order is their order of precedence.

Previous slide

Next slide

Back to first slide

View graphic version