Group By controls the presentation of rows , order by controls the presen

What is the difference between group by and order by?

Question Posted / sunil1405

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

Please Help Members By Posting Answers For Below Questions

How to find the number of rows in a db2 table?

1120

What is load utility in db2?

1181

How will you return the number of records in table?

937

What is dbrm library?

1056

What is cloudant database?

1097

can we view the access paths created by dbrm ? how ? thx

7098

What is the difference between cursor stability and repeatable read isolation levels?

1175

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

Explain what are the various isolation levels possible?

1044

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

What is the role of union all and union

1129

What is a db2 cursor?

1055

What is copy pending status in db2?

1127

What is db2 optimizer?

1237

Mention the definition of cobol in varchar field.

1250