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
14891 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

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2119

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1809

What is the latest version of ibm db2?

1370