find out the third highest salary?
Answer Posted / nitin berwal
select top 1 salary from(select top 3 salary from emp order
by desc) a
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the max number of columns in an oracle table?
How can Oracle users be audited?
What is merge in oracle?
How many memory layers are in the oracle shared pool?
How to use "if" statements on multiple conditions?
How to list all indexes in your schema?
What is an oracle data file?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the extensions used by oracle reports?
What is an oracle database table?
Differentiate between translate and replace?
What do you mean by a tablespace?
How to define a cusotmer as a supplier in ORACLE R12
What is the difference between primary key and unique key and foreign key in oracle?