Created 5 years ago by mb – Tips – 3 comments – viewed 14,209 times
( +2 / -1 )
find doubletts by db fields.
in this example i will check doublets for 3 tabelfields (col1,col2,col3).
so i will get a subquery with the condition, select and grouping of the tablefields. the having with COUNT() > 1 means: find all records more then one result.