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
How will you identify oracle database software release?
State some uses of redo log files?
What is a trace file and how is it created in oracle?
What is connection pooling in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
What is an oracle wallet?
Does oracle charge for java?
How many types of tables supported by oracle?
Explain the difference between a procedure and a function?
What is a user role in oracle?
Can the query output be sorted by multiple columns in oracle?
What are the different oracle database objects?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
11. Display the client number and name and the client number and name of the person who referred that client.
How to convert characters to dates in oracle?