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 names of all branches in the loan relations,and remove duplicates select distinct branch name from loan The keyword all specifies that duplicates not be removed. select all branch name from loan Database System Concepts,5th Edition,Oct 5,2006 3.11 ©ilberschat乜，Korth and SudarshanDatabase System Concepts, 5 3.11 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 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 names of all branches in the loan relations, and remove duplicates select distinct branch_name from loan The keyword all specifies that duplicates not be removed. select all branch_name from loan