Machine-translated by Google. Questions are authored in English.
Top

Discussion

What does the SQL keyword DISTINCT do ?

  • A.Sorts the result rows
  • B.Eliminates duplicate rows from the result
  • C.Restricts the number of rows returned
  • D.Joins two tables on a common column

Answer: D

Correct answer: Eliminates duplicate rows from the result

DISTINCT removes repeated rows so that each combination of the selected columns appears once. Sorting is the work of ORDER BY and limiting the row count that of LIMIT or its equivalent.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.