select CustomerCode,SiteCode,MaterialCode,BusinessChargerCode,count(*) from LogicStock
where LogicStock.EraseFlag = 0
group by CustomerCode,SiteCode,MaterialCode,BusinessChargerCode
Having count(*)>1
我的积累
最新推荐文章于 2024-04-19 19:51:09 发布
select CustomerCode,SiteCode,MaterialCode,BusinessChargerCode,count(*) from LogicStock
where LogicStock.EraseFlag = 0
group by CustomerCode,SiteCode,MaterialCode,BusinessChargerCode
Having count(*)>1