GATE-2024-CS1(Forenoon)
October 1, 2024Computer-Networks
October 2, 2024Database-Management-System
Question 190 |
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 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. |
Question 190 Explanation:
The given SQL query will display the last names and hire-dates of all latest hires in their respective departments in the location ID 1700. So, correct option is (B).
Correct Answer: B
Question 190 Explanation:
The given SQL query will display the last names and hire-dates of all latest hires in their respective departments in the location ID 1700. So, correct option is (B).
Subscribe
Login
0 Comments