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

How to run queries on external tables?

1049

How to display row numbers with the records?

1080

How to do a full database export?

1111

What is ceil and floor in oracle?

1070

Explain about functional dependency and its relation with table design?

1010

What is oracle analytical function?

1145

What is sharded cluster?

1015

What is the maximum limit on the number of columns in a table?

1087

What is a proxy object?

1064

How to run create database statement again?

1158

What is oracle join syntax?

1004

How to best split csv strings in oracle 9i?

1041

How to upsert (update or insert into a table)?

1000

What is bind variable in oracle 11g?

1039

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270