how to sum the values in sql

Question

1.00/5 (2 votes)

See more:

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

Posted 12-Jun-14 22:28pm

jegan1991

Add a Solution

Comments

agent_kruger 13-Jun-14 4:37am

sir, as you have put up the question i would like to recommend you to go back and try it yourself, it is kind of easy and still i have posted the answer. Sorry if the above statement was rude.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

agent_kruger · Answer 1 · 2014-06-12T22:34:00

Solution 1

sir, it is kind of simple here is the code

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

Posted 12-Jun-14 22:34pm

agent_kruger

PrakashCs.net · Answer 2 · 2014-06-12T22:42:00

SQL

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

how to sum the values in sql

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to sum the values in sql

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us