SQL Strategy - A site to master SQL while executing it on the Web
Home >> SQL Strategy - Duplicate row elimination (DISTINCT)

Duplicate row elimination (DISTINCT)

Learn how to eliminate duplicate rows from extracted records.


--Delete duplicate rows from extracted records
■ Description position of DISTINCT

DISTINCTThe keywords are listed after the SELECT clause; DISTINCT has the ability to remove duplicate rows of records extracted by the SELECT statement.

■ Practice

Now for the Practice, I will give you one Question.

This completes [ Duplicate row elimination (DISTINCT)].