Question Details

Detailed explanation and options for the selected question.

Which SQL clause is used to group rows based on a common value?

A. GROUP BY

B. ORDER BY

C. HAVING

D. DISTINCT

GROUP BY groups rows based on a common value. ORDER BY sorts rows, HAVING filters grouped rows, and DISTINCT removes duplicates.