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 explain plan in db2?

1050

What are concurrency issues?

1171

What is the default page size of buffer pools?

1171

What is host variable in db2 cobol?

1136

Define data page.

1131

Define check constraint.

1129

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

1177

How do you find the maximum value in a column in db2?

1154

What is db2 instance?

1165

What does db2 mean?

1084

Name the various locking levels available?

1133

What is dbrm? When it will be created?

1089

Describe major components of db2?

1145

What is isolation level in db2?

1068

Explain package in db2 and its advantages?

1272