select max(MAXI) from (SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / boby

Answer Posted / boby

select max(MAXI) from
(SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno not IN(SELECT max(slno) FROM EMPLOYEE )
GROUP BY slno)a

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you explain an index?

1331

What does closing a cursor do?

1373

What is application trigger?

1056

How does sql*loader handles newline characters in a record? : aql loader

1092

Is postgresql a nosql database?

1228

What is sqlca in db2?

1036

how do you tune the slow running queries in oracle db , explain the methodology

3230

Explain the significance of the & and && operators in pl sql.

1048

What do you understand by pl/sql cursors?

1148

what are myisam tables? : Sql dba

1077

What is union?

1250

What are the differences between in and exists clause?

1165

What is data manipulation language?

1232

Can function return multiple values in sql?

1098

How do you create a db file?

1068