select sal from emp a where 1=(select count(*) from emp b where a.sal>b.

how to find the second highest salary from emp table?

Question Posted / prudhvi

211 Answers
368412 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / prudhvi

select sal from emp a where 1=(select count(*) from emp b where a.sal>b.sal);

Try this guys,if u want highest sal use 0 in where condition, for second highest 1,third 2........

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql injection vulnerability?

948

What is the purpose of primary key?

1029

What is dml and ddl?

959

what is 'mysqldump'? : Sql dba

1111

how mysql optimizes distinct? : Sql dba

1083

What is pivot table in sql?

1115

What is the left table in sql?

967

Sql technical questions

1283

what does it mean to have quoted_identifier on? : Sql dba

1146

What are types of exception?

922

What is sql prepared statement?

989

how many sql ddl commands are supported by 'mysql'? : Sql dba

1025

What is sql partition function?

1215

What is the syntax and use of the coalesce function?

1175

What is the sql*loader? : aql loader

1056