Sql: using the distinct keyword to get unique values?

Example:

Copy Code
SELECT DISTINCT department FROM employees;

The DISTINCT keyword is used to return only distinct (unique) values.

Solution:

Copy Code
SELECT DISTINCT role, department FROM employees;