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
361134 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 is a file delimiter?

1011

Enlist the advantages of sql.

937

What are all different types of collation sensitivity?

973

what is the stuff function and how does it differ from the replace function? : Sql dba

988

What trigger means?

926

Can we rollback delete command?

930

How to connect a sql*plus session to an oracle server?

1079

What is keys and its types?

1019

What kind of join is join?

903

What are pl sql procedures?

958

Does truncate need commit?

889

List the various privileges that a user can grant to another user?

987

Is sql microsoft?

977

What is a boolean in sql?

943

How do you write an inner join query?

889