How to Select second Maximum salary in a Table ?
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
how to make an oracle object
What is the difference between a primary key & a unique key?
What is instant client oracle?
How to compare dates in oracle sql?
How do you store pictures in a database?
How do we create privileges in oracle?
What do you understand by a database object? Can you list a few of them?
What privilege is needed for a user to create indexes in oracle?
List out the difference between commit, rollback, and savepoint?
How to update values on multiple rows in oracle?
What is the max number of columns in an oracle table?
How to retrieve the count of updated rows?
What is bulk collect in oracle?
What are the varoius components of physical database structure of oracle database?
What is meant by recursive hints in oracle?