mysql 日期范围查询

最新推荐文章于 2025-09-24 10:27:53 发布

原创

最新推荐文章于 2025-09-24 10:27:53 发布 · 976 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #sql

时间段查询

select
                    ifnull(l.num,0) as value,
                    temp.dd as time
                    from (
                    select
                    ifnull(count(1),0) as num
                    ,date_format(bdr.create_time,'%Y%m%d') as time
                    from bil_location_record bdr
                    <where>
                        id IN ( SELECT max( id ) FROM bil_location_record GROUP BY waybill_no )
                        AND retrieval_status = '0'
                        <if test="sites != null and sites.size() > 0">
                            and bdr.storage_outlets_code in <foreach item="siteCode" collection="sites" open="(" separator="," close=")">#{siteCode}</foreach>
                        </if>
                    </where>
                    GROUP BY  date_format(bdr.create_time,'%Y%m%d')
                    ) l right join
                    (