A SQL statement how to find the chain! The number of resumes this month minus last month's (pictured)

How do you find a SQL statement for the chain? The number of resumes this month minus last month's ()

"Number of resumes in the month"-"resumes last month" = "Number of years" ()

How is the SQL statement written?
Selectdate_format (m_adddate, '%m ') as Month,count (m_id) as Zong,date_format (m_adddate, '%Y ') as year from Job_myreceive where Date_format (m_adddate, '%Y ') =2011 GROUP by Date_format (m_adddate, '%m ');

Share to:

------Solution--------------------
Well, write it clearly.

SELECT date_format (a.m_adddate, '%y%m ') as Ym, COUNT (*) as ' month ',

Date_format (a.m_adddate, '%y%m ') = Date_format (Date_add (m_adddate,interval 1 MONTH), '%y%m ')
) as last month
From Job_myreceive a GROUP by 1

Ym     month   last month  
201012 6      
201101 2      
201105 1      
201107 2      
201112 1      
201305 1      0

