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

What does the SQL SELECT DISTINCT statement do?OptionsInserts distinct rows into a tableRetrieves unique values from a columnDeletes duplicate rows from a tableUpdates distinct values in a table

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

How could we choose only unique values in a query?a.SELECT DISTINCTb.SELECT SPECIALc.SELECT UNIQUEd.SELECT NO DUPLICATE

What is the key difference between COUNT and COUNT DISTINCT in a database query?1 pointCOUNT returns the number of records returned by a query. COUNT DISTINCT only returns the number of the distinct records that are returned by the query. COUNT returns the number of values returned by a query. COUNT DISTINCT returns all values in a specified range. COUNT returns the number of columns returned by a query. COUNT DISTINCT only returns the distinct values within those columns. COUNT returns the sum of the values in a specified range. COUNT DISTINCT returns the number of rows in a specified range.