SELECT EACH MONTH LAST 6 MONTHS IN SQL code example

Example: sql where last 12 months

select Dateadd(Month, -12, GETDATE())