How can I change this SQL to only display records where the count > 1
SELECT COUNT(*),
NAME
FROM TABLEA A
GROUP BY NAME;
SPUFI Question - only display counts > 1
Previous topic • Next topic • 2 posts
• Page 1 of 1
SPUFI Question - only display counts > 1
by dp3546dp3546 » Sun May 23, 2010 7:18 am
- dp3546dp3546
- Posts: 3
- Joined: Sun May 23, 2010 7:09 am
- Has thanked: 0 time
- Been thanked: 0 time
Re: SPUFI Question - only display counts > 1
by dp3546dp3546 » Sun May 23, 2010 9:29 am
I think I found it. just add this to the end
HAVING COUNT(*) > 1;
HAVING COUNT(*) > 1;
- dp3546dp3546
- Posts: 3
- Joined: Sun May 23, 2010 7:09 am
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- SQL/SPUFI Question - 2 refs to same table
by dp3546dp3546 » Sun May 23, 2010 7:52 am - 1 Replies
- 1924 Views
- Last post by GuyC
Tue May 25, 2010 1:56 pm
- SQL/SPUFI Question - 2 refs to same table
-
- BATCH SPUFI
by gopal_NKP » Sat May 21, 2011 10:56 am - 1 Replies
- 3883 Views
- Last post by enrico-sorichetti
Sat May 21, 2011 11:33 am
- BATCH SPUFI
-
- SPUFI Output
by narenbade » Fri Nov 23, 2012 7:28 pm - 1 Replies
- 2608 Views
- Last post by dick scherrer
Sun Nov 25, 2012 6:36 am
- SPUFI Output
-
- Multiple counts on same table
by GuyC » Tue Dec 06, 2011 2:16 pm - 1 Replies
- 2318 Views
- Last post by GuyC
Tue Dec 06, 2011 2:27 pm
- Multiple counts on same table
-
- How to Describe a Table in SPUFI or QMF
by prasadnaidu » Tue Aug 18, 2009 8:55 pm - 5 Replies
- 8297 Views
- Last post by swd
Fri Nov 06, 2009 7:28 pm
- How to Describe a Table in SPUFI or QMF