find out the third highest salary?
Answer Posted / chanchal
SELECT MIN(salary) FROM Department WHERE salary IN
(SELECT TOP 3 salary FROM Department ORDER BY salary DESC)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is the difference between a primary key & a unique key?
What is analyze command used for?
How to find the duplicate rows count from employees table in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is index in Oracle?
What is the simplest tool to run commands on oracle servers?
What is recycle bin in Oracle?
What is oracle host variable?
Explain the difference between a procedure and a function?
What is the data pump import utility?
What is ASM (Automatic Storage Management) in Oracle?
How to list all indexes in your schema?
 How to use an oracle sequence generator in a mapping?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?