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 create db2 table in mainframe?

736

What is db2 command?

669

What db2 400?

795

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

679

What is runstats utility in db2?

681

How is the value function used?

713

What is the use of commit in db2?

710

How is deadlock resolved?

744

Explain package in db2 and its advantages?

699

What are the rules for db2 programming?

728

Before you give the explain statement, what are the prerogatives?

654

What is the difference between plan and package in db2?

689

How to check sequence on a table in db2?

693

Is db2 a mainframe database?

648

What is dbrm in db2 database?

666