如何根据条件组得到列的总和

本文介绍了如何根据条件组得到列的总和的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

ALTER PROCEDURE [dbo]。[K_RT_GetProdutstogrid] @branch int AS BEGIN 设置NOCOUNT ON; 选择PS.sno，PD.productname，sum（PS.quantity）作为数量，PS.description来自 K_RT_PurchaseDet PS 内部联接K_RT_ProductDetails PD在PD.sno = PS.product，其中buyby = @ branch PS.quantity，PS.sno，PD.productname，PS.description END i想要在有很多行与同一公司和modelno

ALTER PROCEDURE [dbo].[K_RT_GetProdutstogrid] @branch int AS BEGIN SET NOCOUNT ON; select PS.sno, PD.productname,sum(PS.quantity) as quantity,PS.description from K_RT_PurchaseDet PS inner join K_RT_ProductDetails PD on PD.sno=PS.product where purchasedby=@branch and PSpany=@company and modelno=@modelno group by PS.quantity,PS.sno, PD.productname,PS.description END i want to sum quantity when there are many rows with same company and modelno

推荐答案

查询应该是这样的。您无需在 GROUP BY 子句中输入数量。列顺序应与 SELECT 子句相同。 Query should be like this. You don't need to put quantity in GROUP BY clause. And columns order should be same as SELECT clause. ALTER PROCEDURE [dbo].[K_RT_GetProdutstogrid] @branch int AS BEGIN SET NOCOUNT ON; select PS.sno, PD.productname,PS.description,SUM(PS.quantity) as quantity from K_RT_PurchaseDet PS inner join K_RT_ProductDetails PD on PD.sno=PS.product where purchasedby=@branch and PSpany=@company and modelno=@modelno group by PS.sno, PD.productname,PS.description END