Detailed explanation and options for the selected question.
DISTINCT removes duplicate rows in query results. It does not order results, filter rows, or limit the number of rows.