Bookmark Home Contact
  • Examples
  • Sample Database
#1
SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
ORDER BY
	first_name;
#2
SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
ORDER BY
	first_name
LIMIT 5;
#3
SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
ORDER BY
	first_name
LIMIT 5 OFFSET 3;
#4
SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
ORDER BY
	first_name
LIMIT 3, 5;
#5
SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
ORDER BY
	salary DESC
LIMIT 5;
#6
SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
ORDER BY
	salary DESC
LIMIT 1 OFFSET 1;
#7
SELECT DISTINCT
	salary
FROM
	employees
ORDER BY
	salary DESC
LIMIT 1, 1;
#8
SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	salary = 17000;
#9
SELECT
	employee_id,
	first_name,
	last_name,
	salary
FROM
	employees
WHERE
	salary = (
		SELECT DISTINCT
			salary
		FROM
			employees
		ORDER BY
			salary DESC
		LIMIT 1,
		1
	);
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