find out the third highest salary?
Answer Posted / harikrishna ravipati
select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What suggestions do you have to reduce the network traffic?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to define an oracle cursor variable?
Explain the blob datatype?
ABOUT IDENTITY?
How to use "for" statements in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is ceil and floor in oracle?
How to get execution statistics reports on query statements?
What is the use of oracle?
How to invoke the data pump export utility?
What is the difference between a hot backup and a cold backup in oracle?
How to create a new table in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to assign a tablespace to a users in oracle?