A) select productname from product where cost=(Select max(cost) from pro

I have a table(product),It contain fields(productname,cost).
I want to retrieve the product name ,which cost is second
maximum in the table?

Question Posted / dinesh m

Answer Posted / dinesh m

A)
select productname from product
where cost=(Select max(cost) from product where cost not in
(select max (cost) from product) );

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain package in db2 and its advantages?

1190

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1060

How do you pull up a query which was previously saved in qmf?

1137

List down the types of triggers in the db2 database?

1007

What are foreign keys in db2?

1084

What is the use of db2 optimizer?

1087

What is null in db2?

999

Explain how can you do the explain of a dynamic sql statement?

1104

How do we specify index to include or not during bind process.

2107

How to fetch the last row from the table in SQL (db2)?

1632

What are the various isolation levels possible?

1101

What is lock escalation in db2?

1006

How to get the ddl of a table in db2?

1118

Which isolation level provides maximum concurrency?

1141

What is the clustering index in the db2 database?

986