See faq #8129 Eliminating duplicates in a table.

>Hi all
>
>I have mytable.dbf with an index on empno.
>
>recn() empno
>1 10000
>2 10000
>3 10000
>4 10000
>5 20000
>6 20000
>7 30000
>8 30000
>9 30000
>10 30000
>
>to get mytable after deleting the records number 2,3,4,6,8,9,10
>
>and to keep only
>
>recn() empno
>1 10000
>5 20000
>7 30000
>
>Please help in coding
>Thanks
>PP