[打卡]zy

2024-04-12 12:09:51
135
SELECT employee_id,last_name,department_name,city
from employees,departments,locations
WHERE employees.department_id=departments.department_id
AND departments.location_id=locations.location_id;

SELECT * FROM job_grades;

SELECT last_name,salary,grade_level
FROM employees,job_grades
WHERE employees.salary BETWEEN job_grades.lowest_sal AND job_grades.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;