A)Select product, Max (cost) from product where cost

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 / pratap

Answer Posted / pratap

A)Select product, Max (cost) from product where cost <
(select max (cost) from product);

Is This Answer Correct ?

7 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Mention the various locks that are available in db2.

1024

How do you stop a db2 database in linux?

993

What is a db2 collection?

1022

Describe major components of db2?

1082

Why do chiropractors use drop table?

1085

What is db2 optimizer?

1217

What is dbrm? What it contains?

1149

How can we retrieve the total number of records in RPG & CLLE?

631

What is the maximum No of rows per page?

1053

Give the name of some fields form sqlca.

1058

What is schema in db2?

1007

What is image copy in db2?

993

Explain package in db2 and its advantages?

1190

How can you do the explain of a dynamic sql statement?

1056

How do I connect my db2 database to ibm?

1030