Skip to content
Advertisement

Tag: grouping-sets

oracle sum by column without using union

I have this table: (supply table: how many products in storages) I should write a query to have this result: “Total_except_storage_30” has the total of every product in storages except storage number 30. For example first “total_except_storage_30” is for product_id 1000 in all storages except storage_id 30 and the second is for product_id 1001. *** I am not allowed to

Advertisement