find out the third highest salary?
Answer Posted / manoj
select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is sharded cluster?
Is oracle an open source?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to delete multiple rows from a table in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
how to join query for one source type is oracle another source type is sql server ?
What is the difference between postgresql and oracle?
How to select some columns from a table in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is the difference between view and materialized view in Oracle?
Difference between inner join vs where ?
What is the difference between post-database commit and post-form commit?
What is meant by recursive hints in oracle?
What is index in Oracle?
What is a nested table?