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 / kotravel. b

Answer Posted / kotravel. b

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

THIS will surly give 2^nd max sal ok this correct ans ok....

Is This Answer Correct ?

85 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What is the difference between cross join and natural join?

1014

What is indexing oracle sql?

1097

What are the sql versions?

939

Explain the rollback statement?

1002

Is clustered index a primary key?

946

How can I tell if sql is running?

1062

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1076

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7325

Is pl sql better than sql?

1021

what are the drivers in mysql? : Sql dba

1015

What are the various levels of constraints?

1121

How do I create a sql script?

1096

What are the commands used in sql?

1070

What can I use instead of union in sql?

963

How do I debug a stored procedure?

1109