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 is the purpose of primary key?

1029

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

1001

What is the difference between distinct and unique in sql?

950

What are analytical functions in sql?

1029

What is query execution plan in sql?

1189

When are we going to use truncate and delete?

989

Can we join more than 2 tables in sql?

1022

What is sqlite used for?

1003

how mysql optimizes distinct? : Sql dba

1080

Does user triggers have entry for trigger with compilation errors?

1035

What is benefit of creating memory optimized table?

973

Which nosql database is best?

975

what is bcp? When does it used? : Sql dba

989

Differentiate between % rowtype and type record.

1305

What is pl sql architecture?

962