how to find the fifth highest salary?
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
What is an Entity set?
What is app tier?
What is extension and intension?
What are the the Advantages of DBMS?
What is one tier architecture?
What is DML Compiler?
What is the difference between stored procedures and stored functions in oracle?
What do you mean by atomicity and aggregation?
What is VDL (View Definition Language)?
What is RDBMS KERNEL?
What are the different phases of transaction?
What is difference between 2 tier and 3 tier architecture?
What is tier in database?
What is the Disadvantage in File Processing System?
Explain what are the restrictions that views have to follow? : sql server architect