Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What does the DISTINCT keyword do?

  1. A Sorts the results alphabetically
  2. B Removes duplicate rows from the result set
  3. C Selects only indexed columns
  4. 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.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as