SQL语句-查询费用总和为0的案件号
摘要:
注意group by 和having子句的使用 select a.clmno,sum(a.realpay) from llclaimdetail a where 1=1 group by a.clmno having sum(a.realpay)=0 阅读全文
posted @ 2020-01-09 20:51 ~码铃薯~ 阅读(373) 评论(0) 推荐(0)
posted @ 2020-01-09 20:51 ~码铃薯~ 阅读(373) 评论(0) 推荐(0)
posted @ 2020-01-09 11:05 ~码铃薯~ 阅读(232) 评论(0) 推荐(0)