oracle代码写一个附件查询并将按时间顺序显示次数

最新推荐文章于 2024-10-09 22:24:16 发布

喜欢吃爆米花的小叶子

最新推荐文章于 2024-10-09 22:24:16 发布

阅读量115

点赞数

文章标签： oracle

本文链接：https://blog.csdn.net/m0_53353187/article/details/120740017

版权

<sql id="archDocumentList">
    select
    document_id,
    document_att_name,
    created_date,
    rownum - qcnt batch_num,
    document_att_contenttype,
    document_att_size,
    user_name,
    document_attachment,
    business_id
    from (select b.document_id,
    b.document_att_name,
    b.created_date,
    b.document_att_contenttype,
    b.document_att_size,
    su.user_name,
    b.business_id,
    b.document_attachment,
    (select count(a.document_att_name)
    from XXX a
    where a.document_att_name <![CDATA[ < ]]>
    b.document_att_name) qcnt
    from XXX　b
    left join USER su
    on (b.created_by = su.user_id)
    order by b.document_att_name, b.created_date)
    <where>
        1=1
        <if test="documentAttName != null and documentAttName != ''">and document_att_name = #{documentAttName, jdbcType=VARCHAR}</if>
        <if test="batchNum != null and batchNum != ''">and batch_num = #{batchNum, jdbcType=BIGINT}</if>
        <if test="businessId != null and businessId != ''">and business_id = #{businessId, jdbcType=VARCHAR}</if>
    </where>
</sql>

<select id="getArchDocumentList" resultMap="ArchDocumentListResult">
    select *
    from (<include refid="archDocumentList"/>)
</select>

<select id="getArchDocumentList_COUNT" resultType="Long">
    select count(*)
    from (<include refid="archDocumentList"/>)
</select>