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

Define and explain about progress?

985

Explain the types of database normalization?

984

What is the difference between a catalog and a database?

981

Explain the term specialization.

907

How to drop all foreign keys in database?

1145

What are collection pools? What are the advantages?

941

What are data modelling tools?

972

What is meant by a database?

1049

What are records and fields in a database?

1172

I want to export the data date to date from oracle database then what can i do?

2663

How we can connect the Webform pages with database?

1010

What is the role of database server in database management system?

918

What are the limitations of rdbms?

1008

Explain the term entity in dbms?

942

What is database schema in dbms?

1152