ONE DIFF IS IN GROUP BY WE CANT USE MORE FIELDS DISPLAY BUT HERE WE CAN USE IT BY WINDOW FUNCTION. SELECT TRANSACTION_ID,STORE,SALES_AMOUNT, SUM (SALES_AMOUNT) OVER (PARTITION BY STORE) AS TOTAL FROM ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results