engineering computer science MCQ #725

What is the purpose of the SQL GROUP BY clause?

engineering computer science MCQ #725

  1. Question 1

    Q1. What is the purpose of the SQL GROUP BY clause?

    • A) To filter data based on conditions
    • B) To sort data in ascending or descending order
    • C) To group data based on one or more columns
    • D) To join two or more tables

    Answer: To group data based on one or more columns

    Explanation: The GROUP BY clause groups data based on one or more columns, allowing aggregate functions to be applied to each group.