Page 1 of 1
Ch11p3: Print the employee IDs and job IDs of those employees who currently have a job title that is the same as their j
Posted: Thu May 05, 2022 1:38 pm
by answerhappygod
- 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 31 times
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