Question

To eliminate duplicate values, put into the Select clause the key word:

a) Redundant
b) Only
c) Distinct
d) Unique

Answer 1

The keyword to eliminate duplicate values in an SQL query is 'Distinct', which ensures all rows in the result set are unique.

Step-by-step explanation:

To eliminate duplicate values in a query, you should use the keyword Distinct in the Select clause of a SQL statement. This command instructs the database to return only unique values from the specified column(s), ensuring that each row in the result set is different from all the others. It's useful when you want to list all different values that a column contains without any repetition.