>SELECT COUNT(Sin) as DupCnt, Sin + DTOS(Add_date) + Add_time AS pKey ; > FROM SheenaTable ; > GROUP BY pKey; > INTO CURSOR cDuplicates ; > HAVING DupCnt > 1 >>
>>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 >>>>