Re: help with newbie logic.

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/