Hi I need a Query from the month 112013 to 122013 sir......

i have used the below Query which is not satisfieing.

SELECT Emp,

SUM (AMOUNT),

Monthyear

FROM table WHERE MonthYear between 112013 and 122013

GROUP BY Emp

Sorry to say ,if it very easy thing i wont put in here.

anyhow thanks for your replay