Finding a duplicate transaction number

[Chris Hanlon]

I have a problem with a 3rd party piece of software. Doesn't matter which, really. The problem lies
in a table called payments, with a column called txnumber...the newest version of this software fails
a check during installation with the message "duplicate txnumber in payment table." Not sure how
this could have happened, since there is no way to manually assign the txnumber, but the point is
not important. What I'd like to do is figure out a sql script that will return only the duplicate number(s)
so that I can either remove or change them manually. Unfortunately, I'm not terribly familiar with sql.

Any suggestions?

[patrick fediere]

You could do something like that
select Count(*), txnumber from TheTableContaining_txnumber group by txnumber having count(*) >1
You will get a list of the txnumber key present more than 1 time (and how much).
Good hunt.
Patrixk
On 1/16/99 9:54:04 AM, Chris Hanlon wrote:
> I have a problem with a 3rd party piece of software. Doesn't matter
> which, really. The problem lies
in a table called payments, with a column
> called txnumber...the newest version of this software fails
a check
> during installation with the message "duplicate txnumber in payment
> table." Not sure how
this could have happened, since there is no way
> to manually assign the txnumber, but the point is
not important. What
> I'd like to do is figure out a sql script that will return only the
> duplicate number(s)
so that I can either remove or change them manually.
> Unfortunately, I'm not terribly familiar with sql.

Any suggestions?

[Shashu Habtu]

On 1/16/99 9:54:04 AM, Chris Hanlon wrote:
> I have a problem with a 3rd party piece of software. Doesn't matter
> which, really. The problem lies
in a table called payments, with a column
> called txnumber...the newest version of this software fails
a check
> during installation with the message "duplicate txnumber in payment
> table." Not sure how
this could have happened, since there is no way
> to manually assign the txnumber, but the point is
not important. What
> I'd like to do is figure out a sql script that will return only the
> duplicate number(s)
so that I can either remove or change them manually.
> Unfortunately, I'm not terribly familiar with sql.

Any suggestions?