October 21, 2024
Chicago 12, Melborne City, USA
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

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video