w3resource
SQL exercises

SQL exercises on employee Database: List the unique jobs of department 2001 and 3001 in descending order

SQL employee Database: Exercise-76 with Solution

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

76. Write a query in SQL to list the unique jobs of department 2001 and 3001 in descending order.

Sample table: employees


Sample Solution:

SELECT DISTINCT job_name
FROM employees
WHERE dep_id IN (2001,
                 3001)
ORDER BY job_name DESC;

Sample Output:

 job_name
----------
 SALESMAN
 MANAGER
 CLERK
 ANALYST
(4 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 employees in ascending order on job name and descending order on employee id.
Next: Write a query in SQL to list all the employees except PRESIDENT and MANAGER in ascending order of salaries.

What is the difficulty level of this exercise?