Generating subtotal reports direct from SQL

I'm hoping there's a real easy way of doing this that I'm just missing:

Given a Select statement such as:

Select ID, code, amount from foo where code < 10;

that gives me a table like this:

ID code amount
_____________________________________
1 4 20
2 3 10
3 4 15
4 2 10
5 3 9
6 3 8

I want to generate a report table like the following (group by code):

ID code amount
_____________________________________
4 2 10
2 10
2 3 10
5 3 9
6 3 8
3 27
1 4 20
3 4 15
4 35
72

Such that the final table has additional subtotal rows with the
aggregate sum of the amounts. I'm thinking I can generate two tables
and merge them, but is there an easier way using a fancy Select
statement?

-Owen