select * from emp a where 2=(select count(distinct sal) from emp b where a

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

Question Posted / anil_abbireddy

Answer Posted / anil_abbireddy

select * from emp a where 2=(select count(distinct sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

44 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How to execute a stored procedure?

1091

How to start oracle sql developer?

1037

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1190

What is a temp table?

1026

How delete all data from all tables in sql?

946

what is the difference between delete and truncate commands? : Sql dba

1070

Can you sum a count in sql?

1011

What is sqlcommand?

1032

Why do we use function in pl sql?

1065

How would you convert date into julian date format?

1006

What is your daily office routine?

2271

Explain about various levels of constraint.

949

Define join and name different types of joins?

1008

Can I join the same table twice?

1045

What is where clause in sql?

1040