Page 1 of 1

SPUFI Question - only display counts > 1

PostPosted: Sun May 23, 2010 7:18 am
by dp3546dp3546
How can I change this SQL to only display records where the count > 1

SELECT COUNT(*),
NAME
FROM TABLEA A
GROUP BY NAME;

Re: SPUFI Question - only display counts > 1

PostPosted: Sun May 23, 2010 9:29 am
by dp3546dp3546
I think I found it. just add this to the end

HAVING COUNT(*) > 1;