SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL) FROM EMPLOYEE

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

Question Posted / sandip

69 Answers
118275 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / sandip

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

I don't think this will work correct me if i am
wrong.Correct one is-------

SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and natural join?

1001

Name the operator which is used in the query for pattern matching?

943

What is before trigger?

999

What are types of joins?

963

What is before and after trigger?

955

How is data stored in sql?

1058

Compare sql & pl/sql

1131

Can you have more than one key in a database?

932

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What is sorting in sql?

941

what is the difference between char and varchar data types? : Sql dba

1098

How do I create an index in word?

1029

Define a temp table?

1016

what does the t-sql command ident_incr does? : Transact sql

1075

What is auto increment feature in sql?

1122