使用bito处理数据
通过数据库找出只有一个还款类型的借据
SELECT due_bill_no ,COUNT(due_bill_no) from acc_repay.receipt_detail rd WHERE project_no = 'WS10043190001' AND due_bill_no IN ( SELECT due_bill_no FROM acc_cus.cus_user_base ) AND repay_date = '2023-09-12' GROUP BY due_bill_no HAVING COUNT(due_bill_no) < 2;
使用bito帮助处理数据
添加逗号
压缩成一行
在SQL中使用
SELECT * from acc_repay.receipt_detail rd WHERE project_no = 'WS10043190001' AND due_bill_no IN (1000003461,1000042256,1000045852,1000046436,1000046638,1000046715,1000046762,1000046825,1000046838,1000047475,1000047523,1000047535,1000047596,1000047630,1000047650,1000047701,1000047737,1000047785,1000047918,1000047925,1000047927,1000047942,1000047948,1000047958,1000047963,1000048005,1000048024,1000048050,1000048061,1000048079,1000048081,1000048548,1000048923,1000049178) AND repay_date = '2023-09-12';
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步