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 is db dialect?

961

What is a database report?

843

What is data example?

824

What is buffer manager?

872

How to detect the server version?

974

How to lock records in a table?

918

What are the examples of database?

843

What is create database?

905

What does you mean by s4 super key?

958

What is hashing in dbms?

887

Where is data stored in a database?

939

What are the benefits of database management system?

954

What is database partition key?

869

What is the benefit of database?

845

What is a stretch database?

833