find out the third highest salary?
Answer Posted / ayaz mahmood
select max(sal) from emp
where sal= (select max(sal) from emp
where sal< (select max(sal) from emp
where sal< (select max(sal) from emp)))
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to handle exceptions in post production
Please explain joins in oracle?
What is meant by an index?
Can a formula column be obtained through a select statement ?
How to insert a record into a table?
What is a system tablespace?
What is the difference between a hot backup and a cold backup in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
What are the differences between number and binary_float in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
What is proxy method?
What is the use of file param in imp command?
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 a snapshot log?
Can we write dml statement in function in oracle?