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

How many sql databases can you have on one server?

1017

How do you determine the current isolation level? : Transact sql

1068

Explain architecture of sql server notification services?

985

What is a sql statement?

900

what is the use of set statement in tsql? : Transact sql

943

Write a sql select query that only returns each name only once from a table?

959

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

901

Is join same as left join?

978

how many ways to get the current time? : Sql dba

948

How will you distinguish a global variable with a local variable in pl/sql?

1091

How many tables can a sql database have?

925

How do I view tables in sql developer?

884

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

What is the difference between an inner and outer join?

960

How to fetch alternate records from a table?

1158