What does the DISTINCT keyword do?
- A Sorts the results alphabetically
- B Removes duplicate rows from the result set
- C Selects only indexed columns
- D Returns only the first row
Answer
Removes duplicate rows from the result set
DISTINCT deduplicates across all selected columns. On large result sets it requires sorting or hashing, so it carries a real cost.





