Hi

Lets say I have a table defined as:

CREATE TABLE TEST (
TY INTEGER,
AMOUNT NUMERIC(15,2) DEFAULT 0);

If this contains this:

0,100
1,200
0,200
1,300
0,300

An SQL statement like

Select
ty,
SUM(Amount)
from Test
Group by
ty

gives me this:

0,600
1,500


Can I make an SQL that returns something like this:

600,500

In short - I would like to have both SUM returned on the same line...


Regards
Michael