devxlogo

Rolling 12-Month Totals

Rolling 12-Month Totals

Question:
I have two similar tables with monthly data: one holds current year data and the other holds prior year data. How do I combine them to create a rolling 12-month view or table?

Answer:
If I understand your question correctly, you can use UNION to combine the results of two SELECT statements. Here’s an example:

SELECT AccountID, Amount, Month, YearFROM Table1UNIONSELECT AccountID, Amount, Month, YearFROM Table2ORDER BY Year DESC, Month DESC

This will give you a resultset with the information from both years.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist