Question

To eliminate duplicate values, put into the SELECT clause the keyword ________.

1) DISTINCT
2) UNIQUE
3) REMOVE
4) DUPLICATE

Answer 1

To eliminate duplicate values within a SQL query, use the keyword DISTINCT in the SELECT clause. It ensures that the results are unique and no duplicate data is returned.

Step-by-step explanation:

To eliminate duplicate values in a SQL query, you should put into the SELECT clause the keyword DISTINCT. This keyword ensures that the results returned by your SELECT query are unique, effectively removing any duplicates that may arise from your query. For example, if you want to select all unique names from a table named 'users', your SQL query would look like:

SELECT DISTINCT name FROM users;

Using DISTINCT guarantees that each name is listed only once, even if there are multiple entries for the same name in the users table.