Select min(sal) from emp where sal in ( select top 3 sal from emp order

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / google

Answer Posted / google

Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we need pl sql?

934

What is auto increment in sql?

1060

What is error ora-01000: maximum open cursors exceeded

1059

When do we use triggers?

1025

how do you tune the slow running queries in oracle db , explain the methodology

2038

How can I delete duplicate rows?

963

What are different types of sql commands?

1021

How to select unique records from a table?

998

What is percent sign in sql?

1212

What are hotfixes and patches?

882

Can two tables have same primary key?

915

What is anonymous block in sql?

1070

Why do you partition data?

962

what are the types of join and explain each? : Sql dba

989

Explain character-manipulation functions?

1066