Thanks Jining

From: MadG <patrick4133_at_hotmail.com>
Date: Wed, 07 Feb 2001 00:06:31 GMT
Message-ID: <bk0g6.71454$KP3.20638350@news3.rdc1.on.home.com>

Just wanted to say thank-you!

Jining Han <hanj_at_mailcity.com> wrote in message news:95q2me$4mn$1_at_nnrp1.deja.com...
> In article <oy%f6.71058$KP3.20532325_at_news3.rdc1.on.home.com>,
> "MadG" <patrick4133_at_hotmail.com> wrote:
> > Hi again,
> >
> > I'm having a hard time with the syntax of the following.
> >
> > The number of cd's where there is more than 2 cd's.
> >
> > Same field in the same table. All I keep coming up with is errors.
> >
> > Thanks in advance :)
> >
> > Pat
> >
> >
> One way to do this:
>
> select count(cd) from cd_table group by cd having count(cd)>2;
>
> --
> Jining Han
> Sallie Mae
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Feb 06 2001 - 18:06:31 CST