Domanda di colloquio di GLG
During phone screen: "What does GROUP BY do in SQL?"
Risposta di colloquio
Anonimo
18 gen 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.