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 difference between procedure and trigger?

980

What are pl sql data types?

1009

Why stored procedure is better than query?

946

What are the different types of database management systems?

1001

Is inner join same as self join?

1113

Explain sql data types?

1092

what is a record in a database ? : Sql dba

1061

How do you clear the screen in sql?

1066

What is sql stand for?

983

Where do we use pl sql?

993

Explian rowid, rownum?

1012

Explain autonomous transaction.

1154

what is a tablespace? : Sql dba

1051

describe transaction-safe table types in mysql : sql dba

1006

Explain the steps needed to create the scheduled job?

1038