RE: using sql

From: <kang-wen.k.w.wong_at_ssi.shell.com.my>
Date: Tue, 15 Aug 2000 16:52:34 +0800
Message-Id: <10590.114579@fatcity.com>

bre on grp_no skip 1 on report
comp sum label '' of amt on grp_no
comp sum label 'Grand' of amt on report
select grp_no, so so# , amt from x order by 1 /

-----Original Message-----
From: grace lim [mailto:mglim_at_softhome.net] Sent: 15 Ogos 2000 14:45
To: Multiple recipients of list ORACLE-L Subject: using sql

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.
247-41-34

-- 
Author: grace lim
  INET: mglim_at_softhome.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 15 2000 - 03:52:34 CDT