Ok, I lied....
It does what I thought it would... My grouped records appear to contain the
min value from each respective column, and not the entire record as it
should.
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
> -----Original Message-----
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 24, 2001 12:45 PM
> To: SQL
> Subject: RE: Using DISTINCT on a single column of a multi-column select
> st atement
>
>
> > No it wouldn't. That's the purpose of the GROUP BY.
>
> Worked like a charm, thanks!
>
> -Cameron
>
> --------------------
> Cameron Childress
> elliptIQ Inc.
> p.770.460.1035.232
> f.770.460.0963
> --
> http://www.neighborware.com
> America's Leading Community Network Software
>
>
>
>
>
> > -----Original Message-----
> > From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, August 24, 2001 11:27 AM
> > To: SQL
> > Subject: RE: Using DISTINCT on a single column of a multi-column select
> > st atement
> >
> >
> > > Looks good, but consider these two records
> > >
> > > [EMAIL PROTECTED], cam, childress, 2
> > > [EMAIL PROTECTED], albert, reynolds, 7
> > >
> > > Would your query return the following?
> > >
> > > [EMAIL PROTECTED], albert, childress, 2
> >
> > No it wouldn't. That's the purpose of the GROUP BY.
> >
> > Funnily enough there's a thread on GROUP BY going
> > on over at cf-talk right now.
> >
> > Nick
> >
> >
> > **********************************************************************
> > Information in this email is confidential and may be privileged.
> > It is intended for the addressee only. If you have received it in error,
> > please notify the sender immediately and delete it from your system.
> > You should not otherwise copy it, retransmit it or use or disclose its
> > contents to anyone.
> > Thank you for your co-operation.
> > **********************************************************************
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
