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

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

Question Posted / omkar hendre

69 Answers
118294 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / omkar hendre

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is varchar sql?

1131

What is pl sql block structure?

1034

Enlist the characteristics of pl/sql?

1796

How can I change database name in sql?

1078

what is myisam? : Sql dba

1076

What is identity column in sql server?

1046

What are the most important characteristics of pl/sql?

1151

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1122

What is sql*loader?

1180

What is an implicit commit?

1048

How to convert comma separated string to array in pl/sql?

1177

What operators deal with null?

1099

What is meant by truncate in sql?

1063

Show the two pl/sql cursor exceptions.

1189

What is hibernate and its relation to sql?

1119