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

Explain 5nf?

613

How do you open .db files?

540

How to move a multi-file database?

593

What is raid controller technology?

610

What is database bloat?

564

Why do not you use gnu autoconf or scons for building?

616

Define weak entity set.

724

What are the advantages of manual database?

560

What is database definition (dbd)?

555

Explain the importance of database partitioning.

585

Why not phenix, the zelinka/otwinoski libraries, etc?

713

What are different partitioning techniques in database?

545

what do u mean by implementation?

1674

What are different types of data models?

580

What is database or database management systems (dbms)?

556