如何在sql中对值进行求和 [英] how to sum the values in sql

问题描述

在表格记录中如下





课程批量反馈项MQ1 MQ2 MQ3 MQ4 Entereddate



A B101 1 4 5 3 2 9 jun 2014

B B102 2 6 4 9 1 10 jun 2014





i想要将MQ1加到MQ4（4 + 5 + 3 + 2）除以4 = 3.5





为此我怎么写sql

请帮我

In table record as follows


Course Batch Feedbackid MQ1 MQ2 MQ3 MQ4 Entereddate

A B101 1 4 5 3 2 9 jun 2014
B B102 2 6 4 9 1 10 jun 2014


i want to sum the MQ1 to MQ4 (4+5+3+2) divide by 4 = 3.5


for this i how to write the sql
please help me

推荐答案

先生，这里有点简单就是代码

sir, it is kind of simple here is the code

Select ((MQ1+MQ2+MQ3+MQ4)/4.00) As SumOfTotalVal from Table1

CREATE TABLE #MySum(Course VARCHAR(10),Batch VARCHAR(50),FeedbackID INT,MQ1 INT,MQ2 INT,MQ3 INT,MQ4 INT,EnteredDate Date)

INSERT INTO #MySum VALUES ('A','B101',1,4,5,3,2,GETDATE()),
                          ('B','B102',2,6,4,9,1,GETDATE())




                          SELECT * ,(MQ1 +MQ2 +MQ3 +MQ4)  /4.0 'SUM' FROM #MySum

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