Question

In MySQL which keyword is used to return only different values?

Answer 1

The keyword used to return only different values in MySQL is DISTINCT.

Step-by-step explanation:

In MySQL, the keyword used to return only different values is DISTINCT. By using the DISTINCT keyword, you can retrieve unique values from a specific column in a table. This can be useful when you want to eliminate duplicate entries from your query results.

For example:

SELECT DISTINCT column_name FROM table_name;

This query will return only the unique values found in the specified column.