Interested to Buy Any Domain ? << Click Here >> for more details...
How to Select second Maximum salary in a Table ?
- 13 Answers
- 16180 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / arpit sachan
select min(Emp_Sal)from Employee_Test where Emp_sal in(select distinct top(2) Emp_Sal from Employee_Test order by Emp_Sal desc)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Give the different types of rollback segments.
What is the difference between formal parameters and actual parameters?
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 a trigger and what are its types?
What is Reduced List of Values?
What is the oracle implicit cursor?
Explain a data segment?
Explain overloading. Can functions be overloaded?
What are the restrictions on external table columns?
What is MTTR advisor in Oracle?
What are the logical operations?
What is the difference between online and offline backups?
Difference between hot backup vs. Cold backup?
what is a Nested Loop join?
What is the difference between a primary key & a unique key?
