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

Learn how to eliminate duplicate rows from extracted records.

１．DISTINCTの使い方

--Delete duplicate rows from extracted records


SELECT	DISTINCT JOB,SAL
FROM	EMP

■ 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.

Practice (1/1) Question

Remove duplicate rows of JOBs (jobs) from the EMP Table and display them.

Practice (1/1) Answer

SELECT	DISTINCT JOB
FROM	EMP

This completes [ Duplicate row elimination (DISTINCT)].