You are working with a data set including order records and their ID numbers. While profiling the data, you noticed that there are duplicate values in the "ID" field for each order. You need to create a data set that only shows one record per order, which would create a data set with distinct orders. What keyword can you include in the query to provide a unique list of orders?Select an answer:REMOVE DUPLICATESDELETEDISTINCT

In a database system with an "orders" table, write a query to count the number of unique salespeople.Return the number of unique salespeople.

DISTINCT can be used for removing duplicate tuples in the query result in SQL

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

The Distinct Keyword In Sql Is Used To

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