What is the difference between group by and order by?
- 2 Answers
- 13434 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil1405
Group By controls the presentation of rows , order by
controls the presentation of columns.
| Is This Answer Correct ? | 15 Yes | 7 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What are the two types of logging in the db2 database? Explain them.
What is a Foreign Key?
what is utility for parm lib
What is dbrm library?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Why do we need reorg in db2?
What is db2 stogroup?
What is the physical storage length of timestamp data type?
How is a typical db2 batch pgm executed?
What is db2 purescale?
Explain packages.
What's The Error Code For Unique Index Voilation?
What is a plan and package in db2?
Are views updateable?
