S
Siegfried Heintze
I have a bunch of restaurant receipts in a database and I want to sum all
the items of each receipt. Each row of the result set would be a receipt
number and a sum of the price of the line items.
What might a query like this look like?
Is is possible to write a query that would list all the line items grouped
by receipt numbers with sub totals for each receipt?
Thanks,
Siegfried
the items of each receipt. Each row of the result set would be a receipt
number and a sum of the price of the line items.
What might a query like this look like?
Is is possible to write a query that would list all the line items grouped
by receipt numbers with sub totals for each receipt?
Thanks,
Siegfried