write a query for the fifth highest salary?

Answer Posted / suparna

select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)

Is This Answer Correct ?    8 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of blocks used in stored procedure?

638


Why merge statement is used inside the database?

647


What are the advantages of normalizing a database.

611


Which is the best graph database?

543


Write a query to get maximum and second maximum in oracle?

610






how can we view column head in first page but not in remaining pages?

1612


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

1960


WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

1832


What is the difference between primary key, foreign key and candidate key?

658


Explain phantom deadlock?

793


what is the role of auditor in auditing data oriented applications?

1937


Define stored procedure?

613


What is lagging in DBMS ?

828


Explain the record term used in database.

670


List various types of log-based recovery in DBMS.

577