求助，各位大师，帮忙修改成按月统计，我是菜鸟，详细点，谢谢各位大师！（自动按月统计，显示在主网站上）

<td align="center" height="38" class="MenuFont1">稿件排行</td>
          </tr>
          <tr>
            <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" bgcolor="#CCCCCC" cellpadding="0" style="margin-bottom:15px;">
              <%
              
              sql = "select top 10 * from bigclass where m_ppppid = 68 order by m_num"
              rs.open sql,db,1,1
              while not rs.eof
                  sqll = "select * from newslist where n_bigclassid ="&rs("m_id")&" and n_time between #2012-06-01 00:00:00# and #2012-07-01 00:00:00#"

                rss.open sqll,db,1,1
              %>
              <tr>
                <td align="center" width="60%" bgcolor="#FFFFFF"><%=rs("m_title")%></td>
                <td align="center" bgcolor="#FFFFFF"><%=rss.recordcount%>篇</td>
              </tr>
              <%
                  rss.close
                rs.moveNext
              wend
              rs.close
              %>
            </table></td>

sql = "select top 10 * from bigclass where m_ppppid = 68 order by m_num desc"

麻烦2楼的老师，能不能详细一点，因为我是菜鸟，麻烦了，谢谢！

加一个年月的字段（如YYYYMM），然后直接对表按月汇总可能会更方便些。