如何对行值求和 [英] how to sum the row value

问题描述

我的查询是...........

My Query is...........

SELECT     PatientReg.P_Id, PatientReg.PatientName, PatientReg.Age, PatientReg.ClinicalProb, PatientReg.Mobile, PatientReg.GuardianName, PatientReg.AdmitTime,
                      PatientReg.DPatientId, PatientReg.Relation, Bed.BedId, Bed.BedNo, InTreatment.Total, InTreatment.GTotal

FROM         PatientReg inner JOIN
                      Bed ON PatientReg.BedId = Bed.BedId inner JOIN
                      InTreatment ON PatientReg.P_Id = InTreatment.PatientId

输出是.......... .........



14 Raju 12 serious 1234567890 ramu 24-10-2013 D00014 father 10 12 3 385 4385



14 Raju 12 serious 1234567890 ramu 24-10-2013 D00014 father 10 123 36 91



我想要出去............





14 Raju 12 serious 1234567890 ramu 24 -10-2013 D00014父亲10 123 421 4476

Output is...................

14 Raju 12 serious 1234567890 ramu 24-10-2013 D00014 father 10 123 385 4385

14 Raju 12 serious 1234567890 ramu 24-10-2013 D00014 father 10 123 36 91

And I want The Out ............


14 Raju 12 serious 1234567890 ramu 24-10-2013 D00014 father 10 123 421 4476

推荐答案

您可以使用聚合函数的SQL。查看 http://technet.microsoft.com/en-us/library/ms173454.aspx [ ^ ]



祝你好运

-Amit

Hi,

You can use Aggregate Functions of SQL. Check http://technet.microsoft.com/en-us/library/ms173454.aspx[^]

Best luck
-Amit

SELECT     PatientReg.P_Id
         , PatientReg.PatientName
         , PatientReg.Age
         , PatientReg.ClinicalProb
         , PatientReg.Mobile
         , PatientReg.GuardianName
         , PatientReg.AdmitTime
         , PatientReg.DPatientId
         , PatientReg.Relation
         , Bed.BedId, Bed.BedNo
         , Sum(InTreatment.Total) AS 'InTreatmentTotal'
         , Sum(InTreatment.GTotal) AS 'InTreatmentGTotal'
FROM  PatientReg 
Inner JOIN Bed ON PatientReg.BedId = Bed.BedId 
Inner JOIN InTreatment ON PatientReg.P_Id = InTreatment.PatientId
Group By PatientReg.P_Id
           , PatientReg.PatientName
           , PatientReg.Age
           , PatientReg.ClinicalProb
           , PatientReg.Mobile
           , PatientReg.GuardianName
           , PatientReg.AdmitTime
           , PatientReg.DPatientId
           , PatientReg.Relation
           , Bed.BedId, Bed.BedNo

这篇关于如何对行值求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！