JavaScript is a great language. It has a simple syntax, large ecosystem and, what is most important, a great community. At the same time, we all know that JavaScript is quite a funny language with ...
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