with a as (
select siacct, count(siacct) as cnt
from spbsobdp group by siacct)
select * from a where cnt > 1 order by siacct
Scott
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Tuesday, February 24, 2015 1:19 PM
To: Midrange Systems Technical Discussion
Subject: Locate duplicate accounts in a file
I have a file that is supposed to have one record per account number.
There is at least one duplicate account in the file.
I'm thinking there is a simple(?) way to locate the duplicates with SQL.
But, I am missing something.
I have select siacct, count(siacct) from spbsobdp group by siacct order by siacct
Which produces a nice list. How can I change the output so only those records with count > 1 show?
My first thought is to redirect to a file and then query that. Is there another option?
John McKee
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
