Hi,
Is there any software to search for duplicated texts? or a SQL Query command?
Thanks.
this is to find dup items in TBL_ITEM table
SELECT DISTINCT i1.* FROM TBL_ITEM i1, TBL_ITEM i2
WHERE i1.FLD_MAKEINDEX=i2.FLD_MAKEINDEX
AND i1.FLD_CHARACTER<>i2.FLD_CHARACTER
ORDER BY i1.FLD_MAKEINDEX
SELECT *
FROM TBL_ITEM
WHERE FLD_MAKEINDEX IN
(SELECT FLD_MAKEINDEX
FROM TBL_ITEM
GROUP BY FLD_MAKEINDEX
HAVING (COUNT(FLD_MAKEINDEX) > 1))
ORDER BY FLD_MAKEINDEX
so your saying every line that appears on a server when this command is ran??
If so that means my own partner is a duper which isnt true lol