using sql

From: grace lim <mglim_at_softhome.net>
Date: Tue, 15 Aug 2000 13:34:08 +0800
Message-Id: <10589.114572@fatcity.com>

gurus,

how can i achieve this kind of output using only sql? the table x has the ff: column grp_no, so, and amt

grp_no        so#                amt
    1              234               6.00
                    345                1.00
                                    --------------
                                           7.00

   8              245                 5.00
                   489                  2.00
                   798                  1.00
                                   ----------------
                                            8.00

                grand               15.00

Grace Lim
Suy Sing Comm'l Corp. Received on Tue Aug 15 2000 - 00:34:08 CDT