where 条件筛选当前月份的往前推十二个月的数据
SELECT *
FROM your_table
WHERE your_date_column >= DATEADD(MONTH, -12, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0))
AND your_date_column < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)