>>SELECT field1, field2 , RECNO() AS rn ; >> FROM test2 ; >> INTO CURSOR temp1 >> >>SELECT field1, field2 ; >> FROM temp1 ; >> WHERE field1 + STR(rn) IN ( ; >> SELECT field1 + STR(MIN(rn)) ; >> FROM temp1 GROUP BY field1) >>>>
>SELECT field1, MIN(rn) as rn, count(*) as cntDups ; > FROM temp1 GROUP BY field1 ; > having cntDups>1 ; > into cursor temp2 > >SELECT field1, field2 ; > FROM temp1 ; > WHERE field1 + STR(rn) IN ; > (SELECT field1 + STR(rn) ; > FROM temp2) > >>