﻿ SQL SORTING and FILTERING on HR: Display the details of jobs which minimum salary is greater than 9000 - w3resource

# SQL SORTING and FILTERING on HR Database: Display the details of jobs which minimum salary is greater than 9000

## SQL SORTING and FILTERING on HR Database: Exercise-37 with Solution

37. From the following table, write a SQL query to find details of those jobs where minimum salary exceeds 9000. Return all the fields of jobs.

Sample table: jobs

Sample Solution:

SELECT *
FROM jobs
WHERE min_salary > 9000;

Sample Output:

job_id  |           job_title           | min_salary | max_salary
---------+-------------------------------+------------+------------
AD_PRES | President                     |      20000 |      40000
SA_MAN  | Sales Manager                 |      10000 |      20000
(3 rows)

Relational Algebra Expression:

Relational Algebra Tree:

## Query Visualization:

Duration:

Rows:

Cost:

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

﻿

## 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