sql

<select id="findByDate" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from ws_technique
        where org_id = #{orgId} and
        year >= #{year} and 
        (month >= #{month} OR year >= #{year}) and
        (day >= #{day} OR month >= #{month})
    </select>

大于某年 某月 某天的数据

转载于:https://www.cnblogs.com/yujianhuang/p/7081996.html