SQL BETWEEN: Examples

Examples
Sample Database

#1

SELECT 
    employee_id, first_name, last_name, salary
FROM
    employees
WHERE
    salary BETWEEN 2500 AND 2900;

#2

SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	salary >= 2500
AND salary <= 2900;

#3

SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	salary NOT BETWEEN 2500
AND 2900
ORDER BY
	salary;

#4

SELECT
	employee_id,
	first_name,
	last_name,
	hire_date
FROM
	employees
WHERE
	hire_date BETWEEN '1999-01-01'
AND '2000-12-31'
ORDER BY
	hire_date;

#5

SELECT
	employee_id,
	first_name,
	last_name,
	hire_date
FROM
	employees
WHERE
	hire_date NOT BETWEEN '1989-01-01'
AND '1999-12-31'
ORDER BY
	hire_date;

Table List

countries

SELECT * FROM countries;

departments

SELECT * FROM departments;

dependents

SELECT * FROM dependents;

employees

SELECT * FROM employees;

jobs

SELECT * FROM jobs;

locations

SELECT * FROM locations;

regions

SELECT * FROM regions;

SQL Query

Execute

Clear Beautify Minify

Reload

Result