>If so, this combination should do it (note slight change in first SQL)

SELECT MIN(PrimaryKey) AS pk, SecondaryKey AS sk ;
>FROM Table INTO CURSOR TEMP ;
>GROUP BY 2
>* now choose smaller of two for first column
>SELECT EVAL("MIN(pk,sk)") AS pk, sk FROM temp

Thanks to all who helped me on this.

I chose this approach. I guess all approaches sent are good as well. And, the speed is good as well.