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

What is the difference between left and left outer join?

948

Is a foreign key always unique?

946

How does postgresql compare to oracle/db2/ms sql server/informix?

1038

How to avoid using cursors?

1126

State few characteristics of pl/sql?

971

How do you determine the current isolation level? : Transact sql

1161

What is an inconsistent dependency?

1051

Which language is used in sql?

1065

What is over () in sql?

969

What is trigger types of trigger?

1073

What is loop in pl sql?

1040

How can you get sql*loader to commit only at the end of the load file? : aql loader

1015

What is sqlerrm?

941

Can a foreign key have a different name?

941

i have some prob lem to tell me about my self in interview first round ...

2166