Using the script below how can I get the MAX() date
and the second most max date for each category?

That is I want a result (via a SQL Statement) that
will show the following:

category   date        secondmostrecent
A          01/03/2003  01/02/2003
B          02/03/2003  02/02/2003

CREATE CURSOR xx (category c(1), date d)
INSERT INTO xx VALUES("A", {^2001/01/01})
INSERT INTO xx VALUES("A", {^2001/01/02})
INSERT INTO xx VALUES("A", {^2001/01/03})
INSERT INTO xx VALUES("B", {^2001/02/01})
INSERT INTO xx VALUES("B", {^2001/02/02})
INSERT INTO xx VALUES("B", {^2001/02/03})

SELECT category, MAX(date) date FROM xx GROUP BY category