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
 AD_VP   | Administration Vice President |      15000 |      30000
 SA_MAN  | Sales Manager                 |      10000 |      20000
(3 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: From the following table, write a SQL query to find those employees whose first name or last name starts with the letter ‘D’. Return first name, last name.
Next: From the following table, write a SQL query to find those employees who joined after 7th September 1987. Return all the fields.