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

Why do we use function in pl sql?

1065

What is dml statement?

961

What is rank () in sql?

945

explain the difference between myisam static and myisam dynamic. : Sql dba

947

What is having clause in sql?

969

How to create your own reports in sql developer?

1024

Is record in oracle pl sql?

968

What is sql lookup?

924

Is oracle and sql same?

1016

What is the purpose of a secondary key?

979

What does plv msg allows you to do?

1143

Is a view faster than a stored procedure?

973

what are the advantages of using stored procedures? : Sql dba

1105

Does a user_objects view have an entry for a trigger?

1017

Explain commit, rollback and savepoint.

1004