w3resource

PostgreSQL Restricting and Sorting Data: Display the name and salary for all employees whose salary is out of a specific range


1. Write a query to display the name, including first_name and last_name and salary for all employees whose salary is out of the range between $10,000 and $15,000.

Sample Solution:

Code:

SELECT first_name, last_name, salary 
FROM employees 
WHERE salary NOT BETWEEN 10000 AND 15000;

Sample table: employees


Output:

pg_exercises=# SELECT first_name, last_name, salary
pg_exercises-# FROM employees
pg_exercises-# WHERE salary NOT BETWEEN 10000 AND 15000;
 first_name  |  last_name  |  salary
-------------+-------------+----------
 Steven      | King        | 24000.00
 Neena       | Kochhar     | 17000.00
 Lex         | De Haan     | 17000.00
 Alexander   | Hunold      |  9000.00
 Bruce       | Ernst       |  6000.00
 David       | Austin      |  4800.00
 Valli       | Pataballa   |  4800.00
 Diana       | Lorentz     |  4200.00
 Daniel      | Faviet      |  9000.00
 John        | Chen        |  8200.00
 Ismael      | Sciarra     |  7700.00
 Jose Manuel | Urman       |  7800.00
 Luis        | Popp        |  6900.00
 Alexander   | Khoo        |  3100.00
 Shelli      | Baida       |  2900.00
 Sigal       | Tobias      |  2800.00
 Guy         | Himuro      |  2600.00
 Karen       | Colmenares  |  2500.00
 Matthew     | Weiss       |  8000.00
...
 Pat         | Fay         |  6000.00
 Susan       | Mavris      |  6500.00
 William     | Gietz       |  8300.00
(91 rows)

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



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