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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between a primary key and a unique key?

1062

what are date and time intervals? : Sql dba

1065

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4017

Is sql port 1433 encrypted?

1036

What plvcmt and plvrb does in pl/sql?

1329

What are analytical functions in sql?

1037

what is the difference between blob and text? : Sql dba

1030

How to run pl/sql statements in sql*plus?

1091

What is not equal in sql?

1135

what are date and time functions in mysql? : Sql dba

985

What is the difference between the sql*loader and import utilities? : aql loader

1050

What are local and global variables and their differences?

1101

what is blob? : Sql dba

1155

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1140

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1010