数据测试常用SQ
设置变量@set @data = ‘2021-04-01’ //需要执行才能生效select * from table where data >=@data–查询数据库重复数据select 筛选字段,count(1) from 表 (where查询条件) group by 筛选字段 having count(1)>1select t.vin,count(1) from TM_CUSTOMER_VEHICLE t where MEMBER_AUTO_FLAG =‘1’ group
原创
2021-09-07 17:19:52 ·
192 阅读 ·
0 评论