[打卡]zy
2024-04-12 12:09:51
0
115
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;
评论
登录 | 注册