Database-Management-System
August 29, 2024Functional-Dependency
August 29, 2024Database-Management-System
|
Question 404
|
Consider the following relation schema R along with the tuples.
Employee(name, salary) ={< e1, 10000>,< e2, 5000>,< e3, 2500>, < e4, 7500>,< e5, 8900>,< e6, 9800>}
What is the output of following SQL query?
SELECT name , MAX( salary) FROM Employee WHERE salary<( SELECT MAX (salary) FROM Employee;
|
< e3, 2500>
|
|
|
< e5, 8900>
|
|
|
< e6, 9800>
|
|
|
< e1, 10000>
|
Question 404 Explanation:
The above query is to find the employee whose salary is the second highest
Correct Answer: C
Question 404 Explanation:
The above query is to find the employee whose salary is the second highest