I got it working with a count() command and then group by Thanks for the advise. EX:

Select *, Cnt(*) As Num;
From MyTable;
Group By CountField;
INTO CURSOR FOO