[打卡]谷加伟——多表查询

2024-04-12 12:14:02

170

SELECT e.employee_id,e.last_name,
d.department_id,i.city
FROM employees e,departments d,locations i;
WHERE e.department_id=d.department_id
AND d.location_id=i.location_id;

SELECT e.last_name,e.salary,j.grade_level
FROM employees e,job_grades j
WHERE e.salary BETWEEN j.lowest_sal
AND j.highest_sal;

SELECT e.last_name,e.salary,j.grade_level
FROM employees e,job_grades j
WHERE e.salary >= j.lowest_sal
AND e.salary <= j.highest_sal;

SELECT*FROM employees;

SELECT emp.employee_id,emp.last_name,mgr.employee_id,mgr.last_name
FROM employees emp, employees mgr
WHERE emp.manager_id = mgr.employee_id;