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 a native sql query?

1073

What is a left join?

955

What are the 3 types of behavioral triggers?

1254

How to process query result in pl/sql?

1129

How do I run a sql query?

1023

What is the difference between sql and isql*plus?

1098

What is the use of partition by in sql?

996

What is the difference between join and natural join?

928

Is sqlite free?

975

What are different methods to trace the pl/sql code?

1120

Explain the types of joins in sql?

1035

Define overloaded procedure?

1082

what is self join and what is the requirement of self join? : Sql dba

1145

What is oracle and pl sql?

1119

How to find 3rd highest salary of an employee from the employee table in sql?

1083