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
373219 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

What are triggers in sql?

1061

Can a select statement fire a trigger?

1211

Can we join same table in sql?

1068

Are pl sql variables case sensitive?

1093

What is mutating error in pl sql?

1066

How to install oracle sql developer?

1098

How delete all records from table in sql?

1015

What is a dirty read sql?

1247

What does the sign mean in sql?

1049

How do I install sql?

1046

What is indexing oracle sql?

1150

How to return multiple rows from the stored procedure?

1016

what are date and time intervals? : Sql dba

1105

How to get unique records from a table?

1024

What information is needed to connect sql*plus an oracle server?

1079