Re: Please help on SQL
From: Ahmed <ahmed.dahdouh_at_mns.bt.co.uk>
Date: 1998/03/26
Message-ID: <351A343B.5933F2EC_at_mns.bt.co.uk>#1/1
Date: 1998/03/26
Message-ID: <351A343B.5933F2EC_at_mns.bt.co.uk>#1/1
Try
Nuno Guerreiro wrote:
> On 25 Mar 1998 20:24:03 GMT, "Shetal Sheth"
SELECT a, b
FROM foo
where 1 < (select count(*) from foo)
GROUP BY a, b;
> <sheths_at_bobcat.ent.ohiou.edu> wrote:
>
> SELECT a, b
> FROM foo
> GROUP BY a, b
> HAVING count(*) > 1;
Received on Thu Mar 26 1998 - 00:00:00 CET