select max(sal)from emp where sal <> (select max(sal)from emp) OR

how to find the second highest salary from emp table?

Question Posted / abhi

211 Answers
367834 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 / abhi

select max(sal)from emp where sal <> (select max(sal)from emp)

OR

select max(sal)from emp where sal < (select max(sal)from emp)

OR

select max(sal)from emp where sal != (select max(sal)from emp)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

When should I use nosql database?

1006

What is use of term?

1062

What is sql key?

987

What are the most important characteristics of pl/sql?

1151

Can you rollback after commit?

978

Can %notfound return null after a fetch?

1057

What is mutating table error?

1175

What is an invalid partition table?

1025

What are packages in pl sql and also explain its advantages?

1035

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

how can we optimize or increase the speed of a mysql select query? : Sql dba

942

Enlist some predefined exceptions?

1057

What are the types of records?

988

Which query operators in sql is used for pattern matching?

961

What is dml statement?

954