find out the third highest salary?

Answer Posted / divya

select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In what script is snap$ created? In what script is the scott/tiger schema created?

2251


various types of hints and their usage

2133


What is the difference between I and G in Oracle?

605


How to establish administrator authentication to the server?

562


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2050






What is clustered table in Oracle?

645


How to convert numbers to characters in oracle?

590


How to define a procedure inside another procedure?

551


what are archived logs?

1719


What is a dead lock in oracle?

598


Why does for update in oracle 8 cause an ora-01002 error?

553


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1472


What is Undo Management Advisor in Oracle?

615


Explain oracle insert into command?

632


Can we create database in oracle using command line ?

584