When you use aggregate functions in the SELECT clause to produce summary
information, you use the GROUP BY clause to divide the information into
distinct groups. Your database system uses any column or lost of columns
following the GROUP BY keywords as grouping columns. It is an optional
clause.
The CFOUTPUT is a way to group output. The GROUP parameter eliminates
duplicates in the case where data is sorted by the specified fields.
----- Original Message -----
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 11:43 AM
Subject: Group By..
>
> This is one thing that has always escaped my understanding, and I had
the
> sudden urge to ask.
>
> What is Group By. How is Group By used? What is it used for? ( both
in
> SQL Statements and the group attribute in the CFOUTPUT tag )
>
> Anyone want to take a minute and attempt to explain it to me?
>
>
> --
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
> --
> I'm looking for a room-mate in the Hartford CT area, starting in August
> --
> Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
> http://www.instantcoldfusion.com
> --
> DotComIt, LLC
> database driven web data using ColdFusion, Lotus Notes/Domino
> --
> Far Cry Fly, Alternative Folk Rock
> http://www.farcryfly.com | http://www.mp3.com/FarCryFly
> --
> Change is good
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
