select productname 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 / pc

Answer Posted / pc

select productname from product where cost=(select max(cost) from product where cost<> (select max(cost) from product));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of value function?

1209

What is clone table?

1114

What is meant by union and union all?

1054

What is db2 stogroup?

1223

How do I start db2 in windows?

1141

What does a deadlock mean in DB2?

1219

What's The Percentage Free Space ?

1284

is it compulsory commitment control in journal?

2521

What is performance tuning db2?

1110

How will you return the number of records in table?

988

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2092

What is multi row fetch in db2?

1102

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1237

What is precompiler in db2?

1077

How does db2 sample database connect?

1087