Rajesh

• Sep 9th, 2005

 

Group by is used to fetch a unique data from a column.

khalid el mubarak

• Jan 23rd, 2006

 

i believe a "group by" is used to group selected rows in a table to perform arg functions on them .rows not included in the "group by" clouse and not part of ARG functions cannot be used ...(logical grouping of data) or orerations performed (on groups of data) can be used with the "HAVING" clause to further refine the output.

ex of some ARG  functions : SUM() , MIN(),MAX(), AVG()