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?
- 10 Answers
- 11989 Views
- Fidelity, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is sqlca?
What language is db2 written in?
What are the bind parameters ibm db2?
Define db2 and its databases?
How does cobol compile db2 program?
What is isolation level in db2?
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.
What is the role of the data page in the db2 database?
How to connect to db2 database from windows command line?
How do I change the column size in db2?
What is database alias db2?
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 ?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the benefits of using the db2 database?
What are db2 objects?
