Database Analyst Question:
Download Job Interview Questions and Answers PDF
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.
Download Database Analyst Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain what is a view? | Tell us what are the best practices for data cleaning? |