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

Can we create index on primary key?

1019

How do you delete a table?

1124

What is oracle pl sql developer?

1025

What are types of indexes in sql?

1134

What is sqlexception in java?

1037

What is integrity in sql?

1104

what is the difference between truncate and delete statement? : Transact sql

1121

How to write a query to show the details of a student from students table whose

1062

How do you create a db file?

1068

Does sqlite need a server?

1097

What is a recursive join sql?

1116

What is the maximum number of columns in sql table?

1229

What are the different dcl commands in sql?

1231

Cite the differences between execution of triggers and stored procedures?

1138

how to use in conditions? : Sql dba

1062