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
118476 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);

The 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

Can a composite key be null?

978

what is the bond code in materialized view?

3002

How to use transactions efficiently : transact sql

1058

what are the limitations of identity column? : Transact sql

1108

Is sql a oracle?

978

Which sql statement is used to return only different values?

1003

How do I view an execution plan in sql?

983

How to pipe multiline string to isql?

1005

What is indexing oracle sql?

1105

How many sql databases can you have on one server?

1081

Do stored procedures prevent sql injection?

966

What is %type in pl sql?

966

How do I create a sql database?

996

What normalization means?

977

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1013