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 an exception in PL/SQL? What are the two types of exceptions?

1193

How do you select unique values in sql?

935

Why stored procedures are faster than query?

969

What is the purpose of normalization?

995

Why coalesce is used in sql?

917

What are all the different normalization?

977

what is user defined functions? : Sql dba

975

What is sql profiler in oracle?

1013

what is index? : Sql dba

943

How can you fetch common records from two tables?

1001

What kind of join is join?

903

Define commit?

940

What is pivot query?

1014

What are database links used for?

990

Does oracle use sql?

878