select min(Emp_Sal)from Employee_Test where Emp

How to Select second Maximum salary in a Table ?

Question Posted / arpit sachan

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

Please Help Members By Posting Answers For Below Questions

What are the various types of snapshots ?

996

How many anonymous blocks can be defined?

1132

How to store only time; not date and time?

983

What is Library Cache in Oracle?

1096

What is a nested table and how is it different from a normal table?

1011

What is a read only transaction in oracle?

988

What are the logical operations?

1083

Explain temporal data types in oracle

1056

Explain the use of grant option in imp command.

976

Why oracle is used?

1020

Explain the use of compress option in exp command.

984

What is the parameter mode that can be passed to a procedure?

1005

How to retrieve data from an explicit cursor?

1023

How to define a data source name (dsn) in odbc manager?

991

How to commit the current transaction in oracle?

1064