I have the following data (order of records as in the example): A B 1 10 1 20 1 30 1 40 2 50 2 65 2 75 1 89 1 100 from SQL: with x as ( select A, B from ( select 1 as A, …
Tag: subtotal
Oracle Sql: How to add multi sub total in sql?
I want query multi sub total in query sql. How query multi sub total. please help me. SQL CODE: Result Query: But i want add multi sub total in query. I want Result Query: How add multi row sub total? Help me please. Thanks in advance. 😉 Answer I will post a solution with using the group by rollup extension.