declare @tbl table

(

emp int ,

monthyear int,

amount money

)

insert into @tbl

select 1, 102013 ,1000

union all select 2, 102013, 1000

union all select 1, 112013 ,1000

union all select 1, 112013, 1000

union all select 2, 122013 ,1000

union all select 2 ,122013,0000

select emp, SUM(amount) from @tbl

where LEFT(monthyear,2) = '11' or LEFT(monthyear,2) = '12'

group by emp