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

Which are the different character-manipulation functions in sql?

1059

What are transaction and its controls?

1036

Explain what is sql*plus?

1138

What are the two types of cursors in pl sql?

1073

what is foreign key? : Sql dba

1025

how many ways to get the current time? : Sql dba

1001

What are sql data types?

1018

What is materialized view in sql?

916

What is left join in sql?

1043

What is a table in a database?

1042

What are crud methods?

1025

how can we repair a mysql table? : Sql dba

974

How does postgresql compare to "nosql"?

1029

What is not equal in sql?

1115

I need a function for a train ticket reservation please answer it thanks in advance

1022