SQL exercises on employee Database: Display all the unique job in descending order
SQL employee Database: Exercise-68 with Solution
[An editor is available at the bottom of the page to write and execute the scripts.]
68. Write a query in SQL to display all the unique job in descending order.
Sample table: employees
SELECT DISTINCT job_name FROM employees ORDER BY job_name DESC;
job_name ----------- SALESMAN PRESIDENT MANAGER CLERK ANALYST (5 rows)
Sample Database: employee
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query in SQL to list the details of the employees in ascending order to the department_id and descending order to the jobs.
Next: Write a query in SQL to list the id, name, monthly salary, daily salary of all the employees in the ascending order of their annual salary.
What is the difficulty level of this exercise?
- New Content published on w3resource :
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework