* Assign seq # to each record SELECT cat, date, amount, 0000000000 AS rn ; FROM mytable ; ORDER BY cat, date ; INTO CURSOR crsTest01 READWRITE REPLACE ALL rn WITH RECNO() * Select nn records in each group lnMrn = 2 && 2 rec's SELECT cat, date, amount ; FROM crsTest01 t11 ; WHERE rn < ( SELECT MIN(rn+lnMrn) FROM crsTest01 t12 ; WHERE t12.cat = t11.cat)>I have a table layed out similar to the follownig:
>cat1 date1 amount >cat1 date2 amount >cat1 date3 amount >cat1 date4 amount >cat2 date1 amount >cat2 date2 amount >cat3 date1 amount >cat3 date2 amount >cat3 date3 amount >>
>cat1 date1 amount >cat1 date2 amount >cat2 date1 amount >cat2 date2 amount >cat3 date1 amount >cat3 date2 amount >>