-
Given the following schema: employees (emp-id, first-name, last-name, hire-date, deptid, 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 departments in the location ID 1700. You issue the following query:
SQL > SELECT last-name, hire-date
FROM employees
WHERE (dept-id, hire-date) IN
(SELECT dept-id, MAX (hire-date)
FROM employees JOIN departments USING (dept-id)
WHERE location-id = 1700
GROUP BY dept-id),
What is the outcome?
-
- It executes but does not give the correct result.
- It executes and gives the correct result.
- It generates an error because of pairwise comparison.
- It generates an error because the GROUP BY clause cannot be used with table joins in a subquery.
- It executes but does not give the correct result.
Correct Option: B
It executes and gives the correct result. As we see there is nothing wrong with the Given query so it displays the expected result.
