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>

大于某年 某月 某天的数据

posted @ 2017-06-26 18:59  夜无良  阅读(90)  评论(0编辑  收藏  举报