﻿ SQL SORTING and FILTERING on HR: Display the details of jobs in descending sequence on job title - w3resource

# SQL SORTING and FILTERING on HR Database: Display the details of jobs in descending sequence on job 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|
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|
AC_MGR    |Accounting Manager             |      8200|     16000|
FI_ACCOUNT|Accountant                     |      4200|      9000|

```

Relational Algebra Expression:

Relational Algebra Tree:

## Query Visualization:

Duration:

Rows:

Cost:

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?

﻿

## SQL: Tips of the Day

MySQL export schema without data

```mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql
```

Ref: https://bit.ly/3xzB9dS