how to get second highest salary in SQL(as/4000

Answer Posted / satheeshkumar

Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)

Is This Answer Correct ?    24 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a unique key and primary key and foreign key?

569


What are the types of keys?

514


What are the 3 types of behavioral triggers?

666


What can I use instead of union in sql?

518


how to shut down the server with 'mysqladmin'? : Sql dba

549






How do I view a sql database?

561


What is difference between hql and native sql?

585


What are the indexing methods?

577


what is a constraint? : Sql dba

715


What is an example of translating a date into julian format?

582


What are procedures used for?

529


What is coalesce in sql?

564


what are date and time data types in mysql? : Sql dba

504


What are pl/sql packages?

573


What is error ora-12154: tns:could not resolve the connect identifier specified?

591