you can use following query select max(sal) from emp where sal<(select

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

Question Posted / ruchi

Answer Posted / ruchi

you can use following query
select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you understand by clause in sql?

977

What is authorization and integrity manager?

935

when All datafiles related to a Tablespace are removed ?

1864

Mention the differences between the clustered and non-clustered index

863

What is the best database to use?

858

How does a database partition work?

927

What is the first step in creating a database?

847

Explain meant by 3-tier architecture?

894

What is built_in Subprogram ?

3001

Explain 4nf?

934

Explain the advantages of rdbms?

887

What is table normalization?

881

What is 2-tier architecture?

892

What are the limitations of database?

845

What is variable dbms?

897