Select Max(Sal) From Emp E Where E.Sal < (Select Max(Sal) From Emp)

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / abhay

Answer Posted / abhay

Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is rename in sql?

968

What are the topics in pl sql?

968

What are pl sql procedures?

1020

What are the possible values that can be stored in a boolean data field?

996

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1215

What is the left table in sql?

959

How to get unique records from a table?

959

What is file based approach?

936

Can we use having without group by in sql?

982

how to show all tables with 'mysql'? : Sql dba

1111

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1054

difference between anonymous blocks and sub-programs.

1130

Which are the different types of indexes in sql?

1054

Is pl sql and postgresql same?

1121

what is “go” in t-sql? : Transact sql

1104