Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14288 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 a corelated subquerry?
Mention some fields that are a part of sqlca.
How do I delete a column in db2?
What are bind parameters in db2?
On which levels locks can be applied?
Which are the db2 tools to protect integrity of the database?
What is the difference between cursor stability and repeatable read isolation levels?
What are types of indexes?
Mention the definition of cobol in varchar field.
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 is the difference between using bind () and rebind () methods of naming class?
Why do chiropractors use drop table?
How can deadlocks be resolved?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is cobol db2?
