Randy,

Try

* 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
>

>
>I want to get the oldest 2 dates from each category into a table. I want my table to look like the following:
>
>

>cat1     date1     amount
>cat1     date2     amount
>cat2     date1     amount
>cat2     date2     amount
>cat3     date1     amount
>cat3     date2     amount
>

>
>Any easy way to do this with a select that I am overlooking?