GLG interview question

During phone screen: "What does GROUP BY do in SQL?"

Interview Answer

Anonymous

Jan 18, 2019

Provides a row of data only for each unique value in the grouped column. You can provide aggregation functions for the other columns, such as SUM or COUNT in order to get meaningful data for those.