Untitled
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