Subtotals

[Bonediggler1]

Hello-

I have a query that produces 9 columns, I would like to do a subtotal on the 9th column based on 2 of the returned columns. I cannot get this to work with ROLLUP. Is it even possible?

Thank you!!

 

[SantaMufasa]

Bone,

We could help you more effectively if you please [ul][li]post SQL code to CREATE TABLE and INSERT INTO <table>,[/li][li]post the sample output you wish to see from the data, and[/li][li]indicate what application you will be using to produce the results (e.g., SQL*Plus, TOAD, Java script, et cetera)[/li][/ul]

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.