problem with decode and group by

I need to do a query that returns how many estudents are in each grade of a school, this is my query:

select decode(grade.order,11,count(axgs.cuser),null) "1º",decode(grade.iorder,12,count(axgs.cuser),null)"2º",decode(grade.iorder,13,count(axgs.cuser),null) "3º",decode(grado.iorder,14,count(axgs.cuser),null) "4º" from pro_grades grade,pro_students_x_grades_seccion axgs,pro_school schoolwhere school.cschool=559 and grade.cschool=school.cschool and axgs.cgrade=grade.cgrade group by grade.iorder;

This is the result:

1º 2º 3º 4º
---------- ---------- ---------- ---------- -




15
15
7
15


The result is what i want but i need the numbers to be in just one row, something like:



1º 2º 3º 4º
---------- ---------- ---------- ---------- -
15 15 7 15

Probably is easy but i can`t figure out how to do it,thanks fot the help!!

PD: The results in the first table are in diagonal

woops misread, I think this should do what you want:



it builds a tally with the decode and then adds it up with the sum

I can`t, if i do that i have this error ORA-00937: not a single-group group function

It works! Thanks a lot!

good, BTW this probably should have been posted to the Oracle board