Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help on SQL
Try
SELECT a, b
FROM foo
where 1 < (select count(*) from foo)
GROUP BY a, b;
Nuno Guerreiro wrote:
> On 25 Mar 1998 20:24:03 GMT, "Shetal Sheth"
> <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 CST