find out the third highest salary?

Answer Posted / anish nama

select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please explain compound trigger in oracle?

603


What is the scope of a local variable?

587


What is different types of joins?

580


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1705


How to create id with auto_increment on oracle?

547






What is oracle instant client?

571


How to rename an index in oracle?

621


How do I limit the number of rows returned by an oracle query after ordering?

642


How to experiment a data lock in oracle?

601


please explain.. DB architecture ...

1568


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1741


What is the string concatenation operator in oracle?

570


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1587


How would you best determine why your MVIEW couldnt FAST REFRESH?

1438


How much memory your 10g xe server is using?

584