Which function groups rows containing the same values in a column?
AGROUP IN
BGROUP BY
CGROUP ON
DGROUP UP
Answer & Solution
Correct answer: B. GROUP BY
1. Aggregates are often wanted per category rather than overall.
2. The rows must first be gathered into those categories.
3. GROUP BY is used to group rows of a table that contain the same values in a column.
4. So the answer is GROUP BY.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.