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

How to check last update on table in db2?

626

What is ibm db2 connect?

570

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2274

Define predicate?

643

How to check sequence on a table in db2?

598

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

604

Mention the definition of cobol in varchar field.

686

Is ibm db2 free?

573

What is dpf in db2?

664

Explain the function of data manager.

632

List out the three types of page locks that can be held.

685

What is cobol db2?

568

Give a brief description of db2 isolation levels?

599

How to get the ddl of a table in db2?

675

What is the role of the data page in the db2 database?

585