>How would I write a SQL statement to show all duplicate records only, on a field, with no unique records? > >rec no field1 results => recno field1 >1 a 1 a >2 b 3 a >3 a 4 a >4 a 6 d >5 c 7 d >6 d >7 d >
SELECT field1, COUNT(*) as matchrecs FROM <i>blah</i> GROUPBY field1 HAVING matchrecs > 1INTOCURSOR <i>foo</i>
SELECT * FROM <i>blah</i> WHERE field1 IN (SELECT field1 FROM <i>foo</i>) INTOCURSOR Dups