Re: using sql

What version of Oracle? If you're using 8i, then use cube, or rollup clauses in your query.

If you're not using 8i, (well, of course, I'd suggest an upgrade) then can you use the sum, break command in sqlplus? Are you using sqlplus?

HTH
Lyall Barbour
At 10:44 PM 8/14/00 -0800, you wrote:
>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 - 09:43:51 CDT