OiO.lk Blog SQL Query that adds horizontal and vertical
SQL

Query that adds horizontal and vertical


I have data in a table that consists of expense statements by year. I want to make a SQL query that gives me the sum of the amounts but for a year on a line like in the Excel table that I provided. I tried but I can’t do it. Only one line per year with all totals.



You need to sign in to view this answers

Exit mobile version