Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help on SQL
The correct syntax is:
SELECT a, b, count(*)
FROM foo
GROUP BY a, b
HAVING count(*) > 1;
That is assuming you want to know how many instances of an a,b combination there are in foo.
Have a good life.