sql查询的结果进行在次统计
select OrderID,SUM(Qty) AS[入库数量] From Order where OrderID like '%OrderNo-2388'
create table #Order( ORderID nvarchar(100), Tcount int) insert #Orderselect N'OrderNo-2388', 10000 union allselect N'AAOrderNO-2388', 1000--#1.建立一个临时表, 把Like中的OrderNo输进去create table TableOrderID( OrderID nvarchar(100))insert into TableOrderIDselect N'OrderNo-2388'--#2.查询select b.OrderID, Tcount = SUM(Tcount)from #Order a inner join TableOrderID b on charindex(b.OrderID, a.OrderID) > 0group by b.OrderID/*OrderID TcountOrderNo-2388 11000*/
[解决办法]
select max(OrderID),sum(Qty) AS[入库数量]from(select OrderID,Qty,1 as a From Order where OrderID like '%OrderNo-2388' ) tmp group by a