engineering computer science MCQ #876

What is the purpose of the GROUP BY clause?

engineering computer science MCQ #876

  1. Question 1

    Q1. What is the purpose of the 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 aggregate data using functions like SUM and AVG

    Answer: To group data based on one or more columns

    Explanation: The GROUP BY clause groups data based on one or more columns, allowing for aggregation and analysis.