Multiple choice technology databases

When we use DISTINCT keyword in a SELECT query it will sort the output by the column-name we specified in the DISTINCT clause.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In most SQL implementations (especially Oracle), the DISTINCT keyword performs an implicit sort to identify and eliminate duplicate rows. The returned result set is typically in sorted order based on the DISTINCT columns, though this is implementation-dependent behavior.