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 an instance database?

1055

What os does db2 run on?

989

What is a bind card?

1219

What's The Percentage Free Space ?

1225

What is the clustering index in the db2 database?

1002

What is db2 purescale?

1007

what are bind concepts in db2 cobol?

1096

What are types of indexes?

1077

What is db2 bind process?

1241

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

What is dbrm library?

1065

What is the difference between cursor stability and repeatable read isolation levels?

1179

What is the reason behind not using select * in embedded sql programs?

1116

What is the purpose of rollback and commit?

1196

On which levels locks can be applied?

1134