midT-SQL
What is DISTINCT?
Updated May 17, 2026
Short answer
Removes duplicate rows.
Deep explanation
Returns unique combinations of selected columns.
Real-world example
Unique department list.
Common mistakes
- Using DISTINCT unnecessarily.
Follow-up questions
- Does DISTINCT affect performance?
- Can it be used with multiple columns?