- Ch11p3 Print The Employee Ids And Job Ids Of Those Employees Who Currently Have A Job Title That Is The Same As Their J 1 (52.67 KiB) Viewed 29 times
Ch11p3: Print the employee IDs and job IDs of those employees who currently have a job title that is the same as their j
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Ch11p3: Print the employee IDs and job IDs of those employees who currently have a job title that is the same as their j
Ch11p3: Print the employee IDs and job IDs of those employees who currently have a job title that is the same as their job title when they were initially hired by the company (that is, they changed jobs but have now gone back to doing their original job). You must use the Set Operator INTERSECT and the job_history table to accomplish this. Employee ID Job ID 176 SA REP 200 AD ASST 1 2
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!