engineering computer science MCQ #831

In SQL, what is the effect of the 'GROUP BY' clause?

engineering computer science MCQ #831

  1. Question 1

    Q1. In SQL, what is the effect of the 'GROUP BY' clause?

    • A) It sorts the result set in ascending order
    • B) It groups the result set by one or more columns
    • C) It limits the result set to a specified number of rows
    • D) It removes duplicate rows from the result set

    Answer: It groups the result set by one or more columns

    Explanation: GROUP BY groups the result set by one or more columns, allowing aggregate functions to be applied to each group.