What is the difference between group by and order by?

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


Please Help Members By Posting Answers For Below Questions

What are the bind parameters ibm db2?

615


Why db2 is called db2?

587


How can we read records for specific member in CL? AND rpg?

225


Explain the contents that are a part of dclgen.

649


What is load utility in db2?

652






what is the role of the cursor in db2?

631


When reorg is used?

661


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3109


What is rct?

741


What is clone table?

587


What is nvl in db2?

618


What is syscat in db2?

566


What are iseries servers?

558


Which isolation level provides maximum concurrency?

653


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

689