how to find the fifth highest salary?
- 8 Answers
- 10223 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
Explain about the implementation of stored procedures?
What are page splits? : sql server architect
What is 1 NF (Normal Form)?
What is "transparent DBMS"?
Name the sub-systems of a RDBMS?
What is a query?
what is the difference between LENGTH AND SIZE?
How is the data structure of System R different from the relational structure?
When is a functional dependency F said to be minimal?
What is the difference between layer and tier?
What are the different phases of transaction?
What is one tier architecture?
What is an Entity type?
Explain about the implementation of business logic in stored procedures?
Explain the truncate command? : sql server architect
