Could you help me out with an issue I have in Oracle? Let's say I have a table that tells me about how many items were sold in each month, and looks like so:

What I need in the output is a table that would count the total number of items sold over the period, and would look like this:

I am honestly not sure how to do that. Should I use grouping()? Thank you in advance.

CodePudding user response：

You don't need to use grouping at all just try to plus all columns as a new column Total.

SELECT T.*,
       (January   February   March   April) Total
FROM T