Hi............ SELECT PRODUCTNAME FROM PRODUCT WHERE COST = (SELECT MAX(

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 / mr. cooooool

10 Answers
14294 Views
Fidelity, I also Faced
E-Mail Answers

Answer Posted / mr. cooooool

Hi............

SELECT PRODUCTNAME FROM PRODUCT WHERE COST = (SELECT MAX(COST)
FROM PRODUCT WHERE COST > (SELECT MAX(COST) FROM PRODUCT));

THANKS
REGARDS
RAVINDRA BISHT

Is This Answer Correct ?

13 Yes

15 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the function of data manager.

1031

what is db2 restart?

2135

Explain packages.

1094

What is the use of db2?

1037

Can there be more than one cursor open for any program?

1160

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1077

How can we read records for specific member in CL? AND rpg?

681

Explain about cursor stability?

1025

Is db2 a programming language?

1032

What is the physical storage length of timestamp data type?

1075

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2202

what is a corelated subquerry?

1108

What is buffer pool in the db2 database?

1081

When the like statement is used?

1209

Why do we use cursor?

1085