find out the third highest salary?
Answer Posted / deepal saini
this is the best way to find out thethird highest salary from emp table
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 is a relational database management system?
Explain compound trigger in oracle?
How would you change old and new values in an insert, delete and update triggers?
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.
How to retrieve the count of updated rows?
What is a nested table?
Explain a private synonyms?
How to define a data field as not null?
What are the set operators union, union all, minus & intersect meant to do?
What is a snapshot log?
What is control file used for?
What are data pump export and import modes?
What is oracle used for?
What privilege is needed for a user to create indexes in oracle?
What is oracle latest version?