how to find the fifth highest salary?
- 8 Answers
- 10195 Views
- IBM, Infosys, I also Faced
- E-Mail Answers
Answer Posted / arun
Select max(Employee_Sal) From Employee where Employee_Code
in(Select Top 5 Employee_Code,Employee_Name,Employee_Sal
From Employee Order by Employee_sal desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Brief theory of Network, Hierarchical schemas and their properties
What is tier in database?
What is degree of Relationship type?
Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?
What is an Entity set?
What is SDL (Storage Definition Language)?
What is Relationship type?
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
what is the difference between LENGTH AND SIZE?
What is the Disadvantage in File Processing System?
How is the data structure of System R different from the relational structure?
What do data architects do?
What is internal database?
Explain about the process which takes place to execute a stored routine?
What is 4NF?
