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
In what script is snap$ created? In what script is the scott/tiger schema created?
various types of hints and their usage
What is the difference between I and G in Oracle?
How to establish administrator authentication to the server?
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 ?
What is clustered table in Oracle?
How to convert numbers to characters in oracle?
How to define a procedure inside another procedure?
what are archived logs?
What is a dead lock in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is Undo Management Advisor in Oracle?
Explain oracle insert into command?
Can we create database in oracle using command line ?