SQL Help

JUMPURS · 15 Sep 2009 at 12:14

Hi,

I have the following query in order to check for duplicates in a table

Code:

SELECT MAX(ID) as PONumber FROM [PurchasesTemp]
GROUP BY PONumber
Having Count(*) > 1

The problem is, if there are multiple duplicates, it only returns the last one?

Is there a way i can change it so it will return all the duplicates?

Cheers

JUMPURS · 15 Sep 2009 at 13:43

Sorry, The ID is a unique number, but what is duplicates is PONumber.

In your code, what would i use for [other]?

JUMPURS · 15 Sep 2009 at 14:32

I think the issue is in the SELECT MAX(ID) part. I assume that is only giving me the ID which is the highest one and not all the ID's?

JUMPURS · 15 Sep 2009 at 15:10

Haircut said:
What database?
If Oracle or Sql Server (2005 or later) you can use an analytic query to do this pretty easily.

SQL 2005 mate.