Title: RE: duplicate records check
Hi Neil,
try something like this
SELECT your_field
FROM your_table
GROUP BY your_field
HAVING COUNT(*) 1
Mit freundlichen Grssen
Frank Kalis
Asset Management
ProACTIV___
CiV Versicherungen * PB Versicherungen * PB Pensionsfonds AG
Neustrae 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]