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
- 12482 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
Is db2 relational database?
When the like statement is used?
Highlight all the advantages that are attached to a package.
What is a db2 schema?
What is coalesce in db2?
What is the difference between db2 and oracle?
What is check constraint. Explain with example.
What is dbrm? What it contains?
What is the syntax for creating a table in the db2 database?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What are packages in db2?
Why select is not preferred in embedded sql programs?
What is runstats db2?
What is the advantage in De-normalizing tables in DB2?
What is dbrm?
