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
- 14079 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / ananth
We can also use correlated subquery for this..
Select product from product a where 1 =
(select count(*) from product b where a.cost < b.cost);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What does runstats do in db2?
Highlight all the advantages that are attached to a package.
What is database alias db2?
How do I add a column to a table in db2?
What is null indicator in cobol db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How do I connect my db2 database to ibm?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is innodb buffer pool?
Explain about rct in db2?
What os does db2 run on?
Explain the contents that are a part of dclgen.
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 ?...
What is bind in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
