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;
Example: Solution:Sql: using the distinct keyword to get unique values?
The DISTINCT keyword is used to return only distinct (unique) values.
SELECT DISTINCT department FROM employees;
SELECT DISTINCT role, department FROM employees;