(Select product from product where cost = (Select Max (cost) from product w

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 / vineeth varghese

Answer Posted / vineeth varghese

(Select product from product where cost = (Select Max (cost) from product where cost not = (select max (cost) from product)))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dbrm library?

1077

What is the use of reorg in db2?

1089

Explain about mirror activator disk mirroring?

1018

What is an instance database?

1062

What is the physical storage length of timestamp data type?

1106

What os does db2 run on?

994

What is the maximum length of sqlca?

1535

What is ibm db2 database?

1016

What is the difference between spufi and qmf?

1139

What is buffer pool and list some of them?

1046

Which components manage deadlocks in db2?

1074

How to resolve deadlock issue

20158

How can record locking be achieved in those DB2 versions which do not support it?

1086

Which are the db2 tools to protect integrity of the database?

1129

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222