w3resource
SQL exercises

SQL exercises on employee Database: Display the unique designations for the employees

SQL employee Database: Exercise-3 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

3. Write a query in SQL to display the unique designations for the employees.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: Display the unique designations for the employees

Sample Solution:

SELECT DISTINCT job_name 
FROM employees;

Sample Output:

 job_name
-----------
 CLERK
 SALESMAN
 MANAGER
 PRESIDENT
 ANALYST
(5 rows)

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to find the salaries of all employees
Next: Write a query in SQL to list the emp_name and salary is increased by 15% and expressed as no.of Dollars

What is the difficulty level of this exercise?