w3resource
SQL exercises

SQL exercises on employee Database: Display the unique department with jobs

SQL employee Database: Exercise-10 with Solution

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

10. Write a query in SQL to display the unique department with jobs.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: Display the unique department with jobs

Sample Solution:

SELECT DISTINCT dep_id,
                job_name
FROM employees ;

Sample Output:

 dep_id | job_name
--------+-----------
   3001 | MANAGER
   2001 | ANALYST
   3001 | SALESMAN
   1001 | MANAGER
   1001 | PRESIDENT
   2001 | MANAGER
   2001 | CLERK
   1001 | CLERK
   3001 | CLERK
(9 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 list the emp_id, salary, and commission of all the employees.
Next: Write a query in SQL to list the employees who does not belong to department 2001.

What is the difficulty level of this exercise?