(Select product from product where cost = (Select Max (cost) from product w

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 / vineeth varghese

Answer Posted / vineeth varghese

(Select product from product where cost = (Select Max (cost) from product where cost not = (select max (cost) from product)))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an instance in db2?

983

How to find the number of rows in db2 tables?

996

What is release/acquire in bind?

1057

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

969

What is buffer pool and list some of them?

981

What are the different types of base tables?

1027

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2123

Is the primary key a clustered index?

1078

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1041

What is concurrency?

1150

What is a db2 schema?

1173

Can one database have multiple instances?

1006

Can we update view in db2?

945

What is dbrm?

1046

How do you pull up a query which was previously saved in qmf?

1099