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


Please Help Members By Posting Answers For Below Questions

What is SDL (Storage Definition Language)?

493


What is Relational Calculus?

522


What is the difference between 3 tier and 3 layer architecture?

439


What is a query?

514


What do data architects do?

430






What are the the Advantages of DBMS?

487


What is BCNF (Boyce-Codd Normal Form)?

512


What is system catalog or catalog relation? How is better known as?

492


What is Data Independence?

525


What is 3NF?

523


What is difference between 2 tier and 3 tier architecture?

431


What is database architecture?

403


What is an Entity type?

497


What is VDL (View Definition Language)?

622


Which is super key?

461