A) select productname from product where cost=(Select max(cost) from pro

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 / dinesh m

Answer Posted / dinesh m

A)
select productname from product
where cost=(Select max(cost) from product where cost not in
(select max (cost) from product) );

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between alias and synonym in db2?

1060

Define db2.

1061

What does db2 mean?

954

What is buffer pool?

1026

How is deadlock resolved?

1080

What is access path in db2?

923

What is sqlca’s maximum length?

1096

What is a Foreign Key?

1033

Is db2 relational database?

914

What is cursor stability in db2?

1274

What is runstats and reorg in db2?

1236

What happens in bind step in a db2 program?

912

can we view the access paths created by dbrm ? how ? thx

6967

What is a bind in db2?

977

Mention data types used in db2 ?

1101