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