SELECT fieldOne, SUM(fieldTwo) FROM anCursor GROUP BY fieldOne INTO CURSOR anotherCursor

SET ENGINEBEHAVIOR 70

create CURSOR tmp (id i, Id2 i)
FOR i = 1 TO 100
    INSERT INTO tmp (id, id2) VALUES (i, MOD(i,2))
ENDFOR 
SELECT SUM(id), id2 FROM tmp GROUP BY id2

 SELECT fieldOne, SUM(fieldTwo), fieldTree, fieldFour, ..... FROM anCursor GROUP BY fieldOne INTO CURSOR anotherCursor

CREATE CURSOR test (test C(10))
INSERT INTO test VALUES ("1")

SELECT CAST(test as I) as IntField FROM test

SELECT fieldOne, SUM(fieldTwo), fieldTree, fieldFour, ..... FROM anCursor GROUP BY 1,3,4 INTO CURSOR anotherCursor