Re: Please help on SQL
From: Sam <sjb_at_charm.net>
Date: 1998/03/30
Message-ID: <351FD225.112188F9_at_charm.net>#1/1
Date: 1998/03/30
Message-ID: <351FD225.112188F9_at_charm.net>#1/1
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