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.

• Sam