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 / nitika

Answer Posted / nitika

SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What view means?

927

What is compound trigger?

958

What is pl sql and why it is used for?

1069

What are pl/sql packages?

1035

Is ms sql is free?

951

how many groups of data types? : Sql dba

970

What does := mean in pl sql?

989

Explain the types of joins in sql?

959

How to look at the current sql*plus system settings?

1077

What is raw datatype in sql?

977

Show how functions and procedures are called in a pl/sql block.

1040

How do I edit a trigger in sql developer?

934

What is varray in pl sql?

1005

What is lexical units in pl sql?

1043

Can ddl statements be used in pl/sql?

1066