AM125P4T006 非晶125瓦0.76透明PVB、顶端出极、背板玻璃4mm 21.000000
AM125P4T006 非晶125瓦0.76透明PVB、顶端出极、背板玻璃4mm 2.000000
AM125P4T006 非晶125瓦0.76透明PVB、顶端出极、背板玻璃4mm 2.000000
本想查询如上结果
select itemcode , dscription , quantity from ign1 where docentry ='1147'
group by quantity , itemcode , dscription
得到如下结果:
AM125P4T006 非晶125瓦0.76透明PVB、顶端出极、背板玻璃4mm 2.000000
AM125P4T006 非晶125瓦0.76透明PVB、顶端出极、背板玻璃4mm 21.000000
重复记录行少了