Syntax

SELECT count(au_id), state, city FROM authorsGROUP BY state, city

• 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