Given the following schema:employees(emp-id, first-name, last-name, hire-date,dept-id, salary)departments(dept-id, dept-name, manager-id, location-id)You want to display the last names and hire dates of all latest hires in their respective departmentsin the location ID 1700. You issue the following query:SQLSELECT last-name, hire-dateFROM employeesWHERE (dept-id, hire-date) IN(SELECT dept-id, MAX(hire-date)FROM employees JOIN departments USING(dept-id)WHERE location-id = 1700GROUP BY dept-id);What is the outcome?

Question

Given the following schema:employees(emp-id, first-name, last-name, hire-date,dept-id, salary)departments(dept-id, dept-name, manager-id, location-id)You want to display the last names and hire dates of all latest hires in their respective departmentsin the location ID 1700. You issue the following query:SQL>SELECT last-name, hire-dateFROM employeesWHERE (dept-id, hire-date) IN(SELECT dept-id, MAX(hire-date)FROM employees JOIN departments USING(dept-id)WHERE location-id = 1700GROUP BY dept-id);What is the outcome?

Examsnet · Accepted Answer

Correct Answer is : It executes and gives the correct result.

GATE Computer Science (CS) 2014 Shift 1 Solved Paper