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

Why rdbms is called relational?

967

What is progress apama?

1125

What are the different types of languages that are available in the dbms?

1076

What is the type of image in database?

909

What is the difference between case version and decode version?

1086

What is 3 level architecture dbms?

1053

How easy is netlib to use?

1047

Is there an example how to configure udfaccess setting in firebird.conf?

1001

What do databases contain?

1003

why an information gap exists in most organizations.

1074

What is a key in dbms?

958

What is third normal form?

971

What are the main components of a database in healthcare?

908

What is information schema in database?

1000

What is use of foreign key?

932