SQL SERVER SUM查询 [英] SQL SERVER SUM Query

问题描述

我有以下表格



手机号码MessageStatus总共发送短信总扣除额度

9825589099已交付12 12

9825589099已发送23 23

9825589099已发送25 25





但我想要跟随





手机号码MessageStatus发送的总短信总扣除额度

9825589099交付12 12

9825589099已发送48 48

解决方案

您好您应该尝试此查询，这比之前的查询更好。

 选择 Mobile NO，MessageStatus，SUM（TotalSMSSent）  TotalSMS，SUM （TotalCreditDeducted） as  TotalCredit 来自 table_na me  group   by  MobileNo，MessageStatus 

< blockquote>你忘了 GROUP MessageStatus 栏

  SELECT  MobileNo，MessageStatus，SUM（TotalSMSSent） AS  TotalSMSSent，SUM（TotalCreditDeducted） AS  TotalCreditDeducted 
  FROM  
 [TableName] 
  WHERE  MobileNo = '  9825589099' 
  GROUP   BY  MobileNo，MessageStatus 

根据您的表名和列在以下查询中进行更改名称： -

 选择 Mobile_No，SUM（Total_SMS） as  Credit，SUM（已发送_Total） as 短信来自 test 
  group   by  Mesage_Status，Mobile_No 

I have Following Table

Mobile NO MessageStatus Total SMS Sent Total Credit Deducted
9825589099 Delivered 12 12
9825589099 Sent 23 23
9825589099 Sent 25 25


But I want As Follow


Mobile NO MessageStatus Total SMS Sent Total Credit Deducted
9825589099 Delivered 12 12
9825589099 Sent 48 48

解决方案

Hi You should try this query this is better then previous one.

select Mobile NO, MessageStatus,SUM( TotalSMSSent) as TotalSMS, SUM(TotalCreditDeducted) as TotalCredit from table_name group by  MobileNo ,MessageStatus

You forgot to GROUP the MessageStatus column

SELECT MobileNo, MessageStatus, SUM(TotalSMSSent) AS TotalSMSSent, SUM(TotalCreditDeducted) AS TotalCreditDeducted
FROM
[TableName]
WHERE MobileNo='9825589099'
GROUP BY MobileNo, MessageStatus

make changes in below query as per your table name and column name:-

select Mobile_No,SUM(Total_SMS) as Credit,SUM(sent_Total) as SMS from test
group by Mesage_Status,Mobile_No

这篇关于SQL SERVER SUM查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！