Need SQL script to get the 6 months data month wise

Is this what you are looking for?

select * from table where date of transaction > dateadd (MONTH, -6, GETDATE())