RE: How do I create a SQL SELECT to give me totals on a level break example order number?

[<stefan@xxxxxxxxxx>]

> Example:
> Select * from lib.file
> group by grouping sets (PONUM)

> What I would like to see is

> PO Number  line Vendor  Cost
> 1234              1     abc       10.00
> 1234               2    abc        12.00
> Vendor Total                       22.00

> 1235               1     def         5.00
> 1235               2     def        12.00
> Vendor Total                        17.00

> Company Total                     29.00

I may misunderstand what you are trying to do, but doesn't.

group by rollup  (PONUM)  give you what you want?

Best regards

Stefan