Posted by Stefan Rybacki on 01/11/06 12:34

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Brian wrote:
> 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 *

you have to name each column in the group by clause.

Regards
Stefan

> HAVING ( COUNT(*) > 1 )
>
> Any help?
>
> Brian
>
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)

iD8DBQFDxN9IyeCLzp/JKjARAjSuAJ9ys9iFgsnaFGPXZ2Dj+UuPFviM2ACgoT6U
tqvbYPyKBC/l3hxoMILel/c=
=jIRe
-----END PGP SIGNATURE-----

[Back to original message]