Sql: using the distinct keyword to get unique values?

Example:

SELECT DISTINCT department FROM employees;
The DISTINCT keyword is used to return only distinct (unique) values.

Solution:

SELECT DISTINCT role, department FROM employees;

Beginner's Guide to SQL