mybatis中大于、小于、大于等于、小于等于示例&&mysql查询上一天/星期/月数据......

mybatis中大于、小于、大于等于、小于等于示例

<!-- 查询前N天数据 -->
	<select id="getLastDayFreeeze" resultType="DayFreeze">
	  SELECT 
         <include refid="freezeColumns"/>
      FROM dayfreeze a
      WHERE a.DeviceID = #{deviceId}
        AND TO_DAYS(NOW()) - TO_DAYS(a.sysTime) &lt;= #{dayNum}
        AND TO_DAYS(NOW()) - TO_DAYS(a.sysTime) &gt;= 1
	</select>
	
	<!-- 查询前N个月数据 -->
	<select id="getLastMonthFreeeze" resultType="DayFreeze">
	  SELECT 
         <include refid="freezeColumns"/>
      FROM dayfreeze a
      WHERE a.DeviceID = #{deviceId}
        AND PERIOD_DIFF(DATE_FORMAT(NOW(),'%Y%m'),DATE_FORMAT(a.sysTime,'%Y%m')) &lt;= #{monthNum}
        AND PERIOD_DIFF(DATE_FORMAT(NOW(),'%Y%m'),DATE_FORMAT(a.sysTime,'%Y%m')) &gt;= 1
	</select>