Answer Detail: RE: What is the difference between group by and order ...

GeekInterview.com > Interview Questions > Mainframe > DB2

Print |

Question: What is the difference between group by and order by?

Answer: Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement.

October 10, 2006 03:59:57	#1
sul	Member Since: Visitor Total Comments: N/A
RE: What is the difference between group by and order ...
u can use aggregate functions (sum, avg etc) with group by

Back To Question