What is the primary purpose of the GROUP BY clause in SQL?

What is the primary purpose of the GROUP BY clause in SQL?

  1. A.

    To sort rows in ascending or descending order

  2. B.

    To group rows with identical values in specified columns for aggregate processing

  3. C.

    To permanently remove duplicate rows from a table

  4. D.

    To filter rows before retrieval

  5. E.

    To combine records from multiple tables

Attempted by 728 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…