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

Where is database stored?

917

What do you understand by e-r model?

1089

What are the various types of relationships in database? Define them.

944

What do you understand by database triggers?

985

What is network database?

1083

What is data modelling concepts?

968

Explain the term entity set in dbms?

1193

Explain the necessary techniques to control deadlocks?

971

What is the definition of database management system?

1127

Enlist some commands of dml?

997

What is database management used for?

980

What is management system in dbms?

989

What is the purpose of database?

919

How to extract metadata for the entire database?

1145

write a query to retrieve the last day of next month in oracle.

991