如何根据条件组得到列的总和 [英] how to get sum of column based on condition group by

问题描述

ALTER PROCEDURE [dbo]。[K_RT_GetProdutstogrid]

@branch int



AS

BEGIN < br $>


设置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 PS.company=@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 PS.company=@company and modelno=@modelno
group by PS.sno, PD.productname,PS.description

END

这篇关于如何根据条件组得到列的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！