Hi Neil,
1) You could ask for the count of each listed item in a column.
something like:
SELECT item, count(item) from parts GROUP BY item;
2) you could then use
SELECT id,item from parts WHERE item = 'xxx';
to review the double entries.
This is just a general sample, perhaps if you give mo
Title: RE: duplicate records check
Hi Neil,
try something like this
SELECT
FROM
GROUP BY
HAVING COUNT(*) > 1
Mit freundlichen Grüssen
Frank Kalis
Asset Management
ProACTIV___
CiV Versicherungen * PB Versicherungen * PB Pensionsfonds
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
