(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 are packages in db2?

1076

What is cloudant database?

1158

What is null value in db2?

1077

What is the difference between dbm cfg and db cfg file in db2 ?

1591

What are the full forms of spufi and dclgen and why are they used?

1137

Explain in brief how does db2 determine what lock-size to use?

1092

How do I connect my db2 database to ibm?

1087

How to check table size in db2 sap?

1096

Outputs of explain are with matchcols = 0. What does this signify?

1112

What is concurrency?

1304

What is the function of logging in the db2 database?

1172

What kind of database is db2?

1085

What is image copy in db2?

1072

What is bind in db2?

1096

What is null indicator in db2?

1162