Hi Neil,
try something like this
SELECT <your_field>
FROM <your_table>
GROUP BY <your_field>
HAVING COUNT(*) > 1
Mit freundlichen Grüssen
Frank Kalis
Asset Management
ProACTIV_______________________________________
CiV Versicherungen * PB Versicherungen * PB Pensionsfonds AG
Neustraße 62, 40721 Hilden
tel +49 (0) 21 03-34 - 7282
fax +49 (0) 21 03-34 - 7098
mailto:[EMAIL PROTECTED]
internet: www.proactiv.de
> -----Original Message-----
> From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 09, 2003 8:42 AM
> To: [EMAIL PROTECTED]
> Subject: duplicate records check
>
>
> Could any one advise what SQL statement I would need to use,
> to check a
> table for any duplicate records e.g that contain the same
> data within a
> field. Note that I haven't got the field as a unqiue field.
>
> Thanks
> Neil
>
> _________________________________________________________________
> Stay in touch with absent friends - get MSN Messenger
> http://www.msn.co.uk/messenger
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
