Bookmark Home Contact
  • Examples
  • Sample Database
#1
UPDATE employees 
SET 
    last_name = 'Lopez'
WHERE
    employee_id = 192;
#2
SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
WHERE
	employee_id = 192;
#3
SELECT
	*
FROM
	dependents
WHERE
	employee_id = 192;
#4
UPDATE dependents 
SET 
    last_name = 'Lopez'
WHERE
    employee_id = 192;
#5
UPDATE dependents
SET last_name = (
	SELECT
		last_name
	FROM
		employees
	WHERE
		employee_id = dependents.employee_id
);
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