SELECT COUNT(Sin) as DupCnt, Sin + DTOS(Add_date) + Add_time AS pKey ; FROM SheenaTable ; GROUP BY pKey; INTO CURSOR cDuplicates ; HAVING DupCnt > 1>>Hi:
>SELECT cnt(sin) as dupcnt, sin+dtos(add_date) + add_time as pkey ; > FROM sheenatable ; > ORDER BY 1 DESC ; > GROUP by 2 ; > INTO CURSOR cDuplicates >>