I have selected and used sum() over PARTITION for the sales data every month by branch. I have tried group by but then I could not get the branch total sales.I have selected and used sum() over PARTITION f
I have selected and used sum() over PARTITION for the sales data every month by branch. I have tried group by but then I could not get the branch total sales.I have selected and used sum() over PARTITION f