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. Write a query in SQL to display the details of jobs which minimum salary is greater than 9000.

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)

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: Write a query in SQL to display all those employees whose first name or last name starts with the letter D.
Next: Write a query in SQL to display those employees who joined after 7th September, 1987.