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 does joining a thread mean?

548

How do I create an index in word?

542

Explain what is a database?

652

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

567

Is pl sql and postgresql same?

573

Can I learn sql in a week?

554

What is a natural join?

518

what is union? : Sql dba

586

What is sql character function?

544

What are the different sql commands?

521

What is sqlerrm?

548

Explain scalar functions in sql?

587

What is schema in sql?

518

What is oracle sql developer?

606

what are local and global variables and their differences? : Sql dba

542