Posted by Brian on 01/11/06 04:19

Hi

I'm trying to run a statement that finds duplicated records
in a table.
I need to test the following fields are the same and return
these ALL records that have a count of >1

date, orderno, store, storename, dnote, status, product, description, ord,
del, brand, supplier, timestamp

I have tried the following but it didn't work?

SELECT *
FROM table_name
GROUP BY *
HAVING ( COUNT(*) > 1 )

Any help?

Brian

[Back to original message]