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 difference between hql and sql?

992

What is bind variable in pl sql?

980

how to convert numeric values to character strings? : Sql dba

1037

What are system versioned tables?

969

Explian rowid, rownum? What are the psoducolumns we have?

945

What are the limitations of sql express?

988

How to move files from one directory to another in pl sql?

1130

What does select count (*) mean in sql?

964

what are the advantages of using stored procedures? : Sql dba

1061

How do sql triggers work?

989

what is acid property in database? : Sql dba

962

What is the difference between numeric and autonumber?

942

Is delete faster than truncate?

960

Why is pl sql needed?

877

Does sap use sql?

933