The select Clause(Cont.) SQL allows duplicates in relations as well as in query results. To force the elimination of duplicates,insert the keyword distinct after select. Find the department names of all instructors,and remove duplicates select distinct dept_name from instructor The keyword all specifies that duplicates should not be removed. select all dept name from instructor Database System Concepts-6th Edition 3.13 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 3.13 ©Silberschatz, Korth and Sudarshan th Edition The select Clause (Cont.) SQL allows duplicates in relations as well as in query results. To force the elimination of duplicates, insert the keyword distinct after select. Find the department names of all instructors, and remove duplicates select distinct dept_name from instructor The keyword all specifies that duplicates should not be removed. select all dept_name from instructor