in reply to Re: Re: Right Number DB
in thread Right Number DB

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Re: Re: Re: Right Number DB
by rdfield (Priest) on Dec 11, 2003 at 11:04 UTC
    You can limit the results of aggregate function in SQL with the "having" clause: 
    select column1,column2,count(*)
from sometable
group by column1,column2
having count(*) > 2

    [download]

    rdfield

[reply]
[d/l]

In Section Seekers of Perl Wisdom