Database Analyst Question:
Tell us what is the GROUP BY statement used for?
Answer:
GROUP BY is a statement that divides the result for a particular query into groups of rows. It is often used with aggregate functions such as SUM, AVG, MAX, MIN, and COUNT, which calculate information about each group. The SELECT statement returns one row for each group.
| Previous Question | Next Question |
| Explain what is a view? | Tell us what are the best practices for data cleaning? |