|
|
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
Navigation:
[Reply to this message]
|