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

What is the difference between bind and rebind in db2?

1459

What is db2 connect?

1081

Who uses db2?

1057

Can one database have multiple instances?

1058

What is the difference between spufi and qmf?

1137

Explain packages.

1117

What is a page in db2?

1030

Explain how can you do the explain of a dynamic sql statement?

1130

What happens in bind step in a db2 program?

978

Explain about dbrm.

1052

Can we update view in db2?

1007

What is the role of union all and union

1130

Which component is responsible for processing sql statements and selecting access paths?

1135

How can you find out the # of rows updated after an update statement?

1116

What is db2 catalog database?

1050