09 2020 档案

查询分组求和的最大值
摘要：求交易总额的最大值两种方法： SELECT c.merchant_no,SUM(c.transaction_amount) AS tt FROM mer_detail c WHERE c.created_date >"2020-09-01" GROUP BY c.merchant_no ORDER 阅读全文
posted @ 2020-09-09 15:03 pandaly 阅读(414) 评论(0) 推荐(0)