Interested to Buy Any Domain ? << Click Here >> for more details...
How to Select second Maximum salary in a Table ?
- 13 Answers
- 15228 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
What is bulk load in oracle?
What is a system tablespace?
What is an oracle user role?
What is private procedure oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a directory object?
What is oracle rownum?
How to create a table index?
Name the various constraints used in oracle?
How to export several tables together?
How to bring a tablespace offline?
What is Segment Advisor in Oracle?
What is an oracle user account?
What is a tns service name?
