SQL Strategy - A site to master SQL while executing it on the Web
>> 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.
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
This completes [ Duplicate row elimination (DISTINCT)].