We can also use correlated subquery for this.. Select product from produ

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 / ananth

Answer Posted / ananth

We can also use correlated subquery for this..

Select product from product a where 1 =
(select count(*) from product b where a.cost < b.cost);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is load utility in db2?

1183

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

What is rebind in db2?

1073

what is diffrence b/w file-aid tool and file-aid utility???

4897

What is the difference between spufi and qmf?

1136

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2951

Explain about open switch business continuity software?

1140

What is cursor stability in db2?

1363

What are the full forms of spufi and dclgen and why are they used?

1094

What are packages in db2?

1026

What is the physical storage length of date data type?

1258

What is deadlock in db2?

1076

What is innodb buffer pool?

1063

What are the various isolation levels possible?

1124

Which isolation level provides maximum concurrency?

1159