select max(sal) from emp where sal not in (select max(sal) from emp)

write a query to Find the Maximun second value in table?

Question Posted / kavita

Answer Posted / kavita

select max(sal) from emp where sal not in (select max(sal)
from emp)

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to retrive a single data from a database

1107

Do models have limitations?

832

What is mean by dbms?

923

What is order by clause?

870

What is database management definition?

865

What are the lock types?

885

Differentiate table scan from index scan.

950

Enlist some commands of ddl, dml, and dcl.

926

How to reorder the table columns (fields)?

1022

What is concurrency control?

921

Enlist various types of interactions created by dbms?

923

What is database normalization? Explain types of it.

926

How to determine who is and change the owner of database?

888

what are the different kinds of indexing?

932

What is file manager?

868