sql 拼接 concat 保存小数 ROUND

 select pr.id  ,pr.store_id, info.store_name,pr.product_id,
    product.product_name , product.specification , product.unit ,product.generate_manufacturer ,pr.purchase_price as nowPurchasePrice,
   pr.retail_price as nowRetailPrice,(pr.retail_price - pr.purchase_price) AS grossProfit,
    concat(ROUND((pr.retail_price - pr.purchase_price)/pr.retail_price * 100,2),'%') AS grossProfitMargin,
    pr.vip_price as nowVipPrice,pr.scattered_price as nowDisassemblyPrice,pr.vip_scattered_price as nowVipDisassemblyPrice,product.haidian_code
    from t_pos_product_info pr
    LEFT JOIN t_erp_store_info info on pr.store_id = info.id
    LEFT JOIN t_erp_product_info product on product.id = pr.product_id
    <where>
        <if test="dto.companyId != null ">
            and pr.company_id = #{dto.companyId}
        </if>
        <if test="dto.storeId != null and dto.storeId != '' ">
            and pr.store_id = #{dto.storeId}
        </if>
        <if test="dto.keyword != null and dto.keyword != ''">
            and (
            instr(product.haidian_code,#{dto.keyword})
            or instr(product.product_name,#{dto.keyword})
            or instr(product.mnemonic_code,#{dto.keyword})
            or instr(product.bar_code,#{dto.keyword})
            )
        </if>
    </where>
    ORDER BY pr.create_time desc

concat拼接函数 ROUND（ ，2）保留两位小数