SQL IN: Examples

Examples
Sample Database

#1

SELECT
	employee_id,
	first_name,
	last_name,
	job_id
FROM
	employees
WHERE
	job_id IN (8, 9, 10)
ORDER BY
	job_id;

#2

SELECT
	employee_id,
	first_name,
	last_name,
	job_id
FROM
	employees
WHERE
	job_id NOT IN (7, 8, 9)
ORDER BY
	job_id;

#3

SELECT 
    department_id
FROM
    departments
WHERE
    department_name = 'Marketing'
        OR department_name = 'Sales'

#4

SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	department_id IN (2, 8);

#5

SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	department_id IN (
		SELECT
			department_id
		FROM
			departments
		WHERE
			department_name = 'Marketing'
		OR department_name = 'Sales'
	)

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