Re: SQL ENQURIES !

Hi
if you are using sqlplus to generate this report

do a order by invoice_id in you sql
and before running the sql put thses two commands in your sqlplus command file break on invoice_id skip 2
compute sum of subtotal on invoice_id

you can try doing the break and compute combination for other totals

hope this helps

sudershan
consuting dba

Kenny Lim wrote:

> Hi,
>
> I am kinda stuck here trying to create a row below every invoices
> number spaced and totaled. Therefore will be able to get a
> summary overview of the report. Does anyone know how to
> do it ? Please Advise.
>
> Thanks in Advance.
>
> Regards,
>
> Ken
>
> select invoice_id,
> menu_id,
> description,
> quantity,
> (price * quantity) as subtotal,
> (price*quantity * 0.085) as tax,
> (price*quantity * 0.085+price*quantity) as total
> from menus;
> where invoice_id = invoice_id
> and menu_id = menu_id;
>
> Result : (HOW DO I GET A TOTAL SUMMARIZED AT THE END OF EVERY INVOICES?!)
>
> INVOICE_ID MENU_ID DESCRIPTION QUANTITY SUBTOTAL TAX
> TOTAL
> ---------- --------- ------------------------- --------
> - --------- ----- -----
> 1001 1 Peking Spareribs 1
> 9 . 77 9.8
>
> 1002 2 Peking Duck 1
> 7 .60 7.6
>
> 1003 3 Walnut Shrimp 2
> 16 1.36 17.4
>
> 1004 4 Kung Pao Chicken 1
> 7 .60 7.6
>
> 1005 4 Kung Pao Chicken 1
> 7 .60 7.6
> 1005 5 Szechuan Chicken 1
> 7 .60 7.6
>
> 6 rows selected.
Received on Wed Dec 02 1998 - 17:43:47 CST