w3resource
SQL exercises

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


HR database model

Query Visualization:

Duration:

Query visualization of Display the details of jobs which minimum salary is greater than 9000 - Duration

Rows:

Query visualization of Display the details of jobs which minimum salary is greater than 9000 - Rows

Cost:

Query visualization of Display the details of jobs which minimum salary is greater than 9000 - 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.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming