w3resource

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. From the following table, write a SQL query to find the unique designations of the employees. Return job name.

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)

Relational Algebra Expression:

Relational Algebra Expression: Display the unique designations for the employees.

Relational Algebra Tree:

Relational Algebra Tree: Display the unique designations for the employees.

Practice Online


Sample Database: employee

employee database structure

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

Previous: From the following table, write a SQL query to find the salaries of all employees. Return salary.
Next: From the following table, write a SQL query to list the employees’ name, increased their salary by 15%, and expressed as number of Dollars.

What is the difficulty level of this exercise?