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 happens to the current transaction if the session is ended?

1105

Why do we use coalesce function in oracle?

1131

Explain the use of rows option in exp command.

1104

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2246

How to create a testing table in oracle?

1000

What is index in Oracle?

1082

How to create a server parameter file?

1148

Explain an index?

1142

What is redo log?

1074

How to resolve name conflicts between variables and columns?

1044

What is a lookup table in oracle?

982

What is oracle in java?

980

Name the various constraints used in oracle?

1033

What happens if the imported table already exists?

1042

Which environment variables are absolutely critical in order to run the OUI?

2127