Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Select keyfield, count(*) as cnt;
from MyTable ;
group by keyfield ;
having cnt > 1 ;
into cursor mydups
SELECT MyTable
SET order to keyfield && create this if it doesn't exist
SELECT mydups
SCAN
=SEEK(mytable.keyfield,"Mytable","keyfield")
** Skip over first **
SKIP +1 IN MyTable
** Delete rest **
DELETE NEXT (mytable.cnt - 1) IN MyTable
ENDSCAN
USE IN mydups
USE IN MyTable