I can find duplicates fine:
select xmd.partId, parts.title, xmd.name,
count(*) "#dupplicates",
group_concat(xmd.value) "values",
group_concat(xmd.idx) "indexes"
from extra_meta_data xmd
join parts on parts.id = xmd.partId
group by partId, name
having "#dupplicates" > 1;
but most actual duplicates have the same value, so are harmless.
so I'd like to select only the xmd.name rows which have differing values.
Knowing that there can be more than 2 duplicates, i.e. a slef-join is not
enough I think.
Any hints on how to go about this problem please? Thanks, --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
