select * from emp x where 2=(select count(distinct sal) from emp y where

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

Question Posted / tulasi

Answer Posted / tulasi

select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Enlist some commands of dml?

936

What are stored-procedures? And what are the advantages of using them.

982

What exactly is a database?

875

Explain what is a deadlock and mention how it can be resolved?

890

What are the limitations of using a model?

1022

What is inner join in database?

1001

Explain the types of database normalization?

939

What are the three main types of models?

900

What is considered a database?

1005

Mention the different languages present in dbms

958

What are the differences between a dbms and rdbms?

995

What are five types of database models?

902

What is the full meaning of dbms?

1066

Is driver a software?

845

How to prevent concurrent access to my data?

1036