What does the SQL SELECT DISTINCT statement do?OptionsDeletes duplicate rows from a tableRetrieves unique values from a columnUpdates distinct values in a tableInserts distinct rows into a table

What does the SQL JOIN clause do?OptionsSorts rows in a tableDeletes rows from a tableCombines rows from two or more tablesInserts rows into a table

What is the purpose of the SQL UNION operator?OptionsDeletes rows from a tableCombines rows from two or more tables, removing duplicatesCombines rows from two or more tables, including duplicatesSorts rows in a table

What is the purpose of the "DISTINCT" keyword in a SELECT statement?To sort the result setTo limit the result setTo return only different valuesTo count the number of records

The Distinct Keyword In Sql Is Used To

Which of the following statements are TRUE about DISTINCT keyword? [Choose any TWO]DISTINCT keyword can be used in SELECT and WHERE clausesDISTINCT removes duplicates based on column immediately following DISTINCTDISTINCT removes duplicates based on all the columns in the SELECT clauseUsage of DISTINCT should be avoided as far as possible due to performance issues