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?
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 role in db2?
What is page size in db2?
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
Explain about rct in db2?
What is the use of reorg in db2?
How to create db2 table in mainframe?
What is the difference between using bind () and rebind () methods of naming class?
What type of database is db2?
Which are the db2 tools to protect integrity of the database?
What is difference between rollback and commit?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Which isolation level provides highest data integrity?
What is a db2 schema?
what is a corelated subquerry?
Which component is used to execute the sql statements?