SQL Exercise: Details of jobs in descending order by title
SQL SORTING and FILTERING on HR Database: Exercise-27 with Solution
27. From the following table, write a SQL query to find all jobs. Sort the result-set in descending order by job title. Return all fields.
Sample table : jobs
Sample Solution:
SELECT *
FROM jobs
ORDER BY job_title DESC;
Sample Output:
job_id |job_title |min_salary|max_salary| ----------|-------------------------------|----------|----------| ST_MAN |Stock Manager | 5500| 8500| ST_CLERK |Stock Clerk | 2000| 5000| SH_CLERK |Shipping Clerk | 2500| 5500| SA_REP |Sales Representative | 6000| 12000| SA_MAN |Sales Manager | 10000| 20000| PU_MAN |Purchasing Manager | 8000| 15000| PU_CLERK |Purchasing Clerk | 2500| 5500| PR_REP |Public Relations Representative| 4500| 10500| AC_ACCOUNT|Public Accountant | 4200| 9000| IT_PROG |Programmer | 4000| 10000| AD_PRES |President | 20000| 40000| MK_REP |Marketing Representative | 4000| 9000| MK_MAN |Marketing Manager | 9000| 15000| HR_REP |Human Resources Representative | 4000| 9000| FI_MGR |Finance Manager | 8200| 16000| AD_VP |Administration Vice President | 15000| 30000| AD_ASST |Administration Assistant | 3000| 6000| AC_MGR |Accounting Manager | 8200| 16000| FI_ACCOUNT|Accountant | 4200| 9000|
Code Explanation:
The said query in SQL that retrieves all columns of data from the 'jobs' table and orders the rows by the values in the "job_title" column in descending order.
Relational Algebra Expression:
Relational Algebra Tree:
Practice Online
Query Visualization:
Duration:
Rows:
Cost:
Contribute your code and comments through Disqus.
Previous SQL Exercise: Find employees managed by the manager.
Next SQL Exercise: Employees who are Sales Representatives or Sales Men.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
SQL: Tips of the Day
Difference between natural join and inner join
One significant difference between INNER JOIN and NATURAL JOIN is the number of columns returned-
Consider:
TableA TableB +------------+----------+ +--------------------+ |Column1 | Column2 | |Column1 | Column3 | +-----------------------+ +--------------------+ | 1 | 2 | | 1 | 3 | +------------+----------+ +---------+----------+
The INNER JOIN of TableA and TableB on Column1 will return
SELECT * FROM TableA AS a INNER JOIN TableB AS b USING (Column1); SELECT * FROM TableA AS a INNER JOIN TableB AS b ON a.Column1 = b.Column1;
+------------+-----------+---------------------+ | a.Column1 | a.Column2 | b.Column1| b.Column3| +------------------------+---------------------+ | 1 | 2 | 1 | 3 | +------------+-----------+----------+----------+
The NATURAL JOIN of TableA and TableB on Column1 will return:
SELECT * FROM TableA NATURAL JOIN TableB +------------+----------+----------+ |Column1 | Column2 | Column3 | +-----------------------+----------+ | 1 | 2 | 3 | +------------+----------+----------+
Ref: https://bit.ly/3AG5CId
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook