(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 os does db2 run on?

988

What is cursor stability in db2?

1358

What are the prerogatives?

1080

How does coalesce work?

1026

What are bind parameters in db2?

1048

What's The Percentage Free Space ?

1224

Are views updateable?

1163

What is the information associated with sysibm.syslinks table?

1125

What is dclgen (declaration generator)?

1059

What is the physical storage length of the data types date, time, and timestamp?

1090

Why cursor is used in db2?

1036

what is the responsibility of the construction superintendent

2147

What is universal database?

1072

Which isolation level provides highest data integrity?

1118

What is copy pending status in db2?

1127