In SQL, which command is used to SELECT only one copy of each set of duplicable rowsSELECT DISTINCTSELECT UNIQUESELECT DIFFERENTAll of the aboveReview AnswerNext

Which SQL statement is used to return only different values?Select one:a.SELECT DISTINCTb.None of the answers are correctc.SELECT DIFFERENTd.SELECT IDENTICALe.SELECT UNIQUE

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

The result of a SELECT statement can contain duplicate rows.Question 31Select one:TrueFalse

How can you remove duplicate rows from a result set in SQL?

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