engineering computer science MCQ #822

In SQL, what is the effect of the 'DISTINCT' keyword?

engineering computer science MCQ #822

  1. Question 1

    Q1. In SQL, what is the effect of the 'DISTINCT' keyword?

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

    Answer: It removes duplicate rows from the result set

    Explanation: DISTINCT eliminates duplicate rows, ensuring that each row in the result set is unique.