Untitled

mail@pastecode.io avatar
unknown
plain_text
6 days ago
467 B
1
Indexable
Never
SELECT e.employee_id, e.first_name, e.last_name FROM employees e JOIN departments d ON e.department_id =d.department_id JOIN locations I ON d.location_id = L.location_id WHERE Llocation_id = 1700;
SELECT e.employee_id, e.first_name, e.last_name FROM employees e JOIN departments d ON e.department_id =d.department_id JOIN locations 1 ON d.location_id= Llocation_id WHERE L.location_id !=1700;
select * from employees where salary =(select max(salary) from employees);
Leave a Comment