What does the DISTINCT keyword do in a SELECT statement?

Explanation

The DISTINCT keyword in a SELECT statement removes duplicate rows from the result set. This means that each row in the output will be unique based on the specified columns.

Key points

DISTINCT eliminates duplicate rows
Helps in getting unique records
Useful when working with large datasets

Ready to go further?

Start full exam Practice more questions