RE: using sql

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Tue, 15 Aug 2000 12:18:43 +0500
Message-Id: <10590.114575@fatcity.com>

Asking for things used long ago, need to dig out from old stuff, to start with try

BREAK ON Grp_No SKIP 4
SELECT Grp_No, So#, Amt FROM x ORDER BY Grp_No, So#

HTH!. Regards,

Aleem
 -----Original Message-----

From: 	grace lim [mailto:mglim_at_softhome.net] 
Sent:	15 August 2000 11: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 - 02:18:43 CDT