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

how to find the second highest salary from emp table?

Question Posted / prashanth

211 Answers
361439 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 / prashanth

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql lookup?

865

Can I join the same table twice?

996

Is sqlite good enough for production?

950

Does oracle roll back the transaction on an error?

963

Can we insert in sql function?

1027

What do you mean by field in sql?

1037

what are the differences between binary and varbinary? : Sql dba

978

What port does sql server use?

988

what is rdbms? : Sql dba

962

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

3946

Compare sql & pl/sql

1049

How does a self join work?

994

does sql support programming? : Sql dba

993

In what condition is it good to disable a trigger?

971

What are the qualities of 2nf?

975