How to add a single column php/mysql

Question

I'm trying to add a single column in a db query result. I've read about the SUM(col_name) as TOTAL, GROUP BY (col_name2). But is there a way i can only SUM the column without any GROUPing? I a case whereby all col_name2 are all unique.

For example... I have a result with the following col headers:

course_code

course_title

course_unit

score

grade

Assuming this have 12 rows returned into an HTML table. Now i want to perform SUM() on all the values (12 rows) for the column course_unit, in other to implement a GPA school grading system.

How can i achieve this.

Thanks.

if you read a little more, you will find that you can use sum without groupby to have a sum of all retrieved rows ;) — Eineki
– Eineki, Commented Mar 5, 2012 at 12:28

George Cummins · Accepted Answer · 2012-03-05 12:30:49Z

2

SELECT SUM(col_name) as 'total' FROM <table>

GROUP BY is required only if you want to sum subsets of the rows in the table.

answered Mar 5, 2012 at 12:30

George Cummins

29k8 gold badges74 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harshith J.V. · Accepted Answer · 2012-03-05 12:31:26Z

2

You can find sum or any aggregate db functions (such as count, avg, etc) for most cases without using group clause. Your sql query may look something like this:

SELECT SUM(course_unit) as "Total" FROM <table_name>;

answered Mar 5, 2012 at 12:31

Harshith J.V.

8971 gold badge8 silver badges23 bronze badges

Comments

Lasar · Accepted Answer · 2012-03-05 12:33:51Z

0

As comments below have already pointed out: SELECT SUM(course_unit) AS total FROM your_table;. Note that this is a separate query to the one with which you retrieve the table data.

answered Mar 5, 2012 at 12:33

Lasar

5,5274 gold badges27 silver badges22 bronze badges

Comments

Jake · Accepted Answer · 2012-03-05 12:33:33Z

0

This does it in php. I'm not sure how to do it with pure sql

$query = "SELECT * FROM table";
$result = mysql_query($query);
$sum = 0;
while($row = mysql_fetch_assoc($result))
{
    $sum+= intval($row['course_unit']);
}

echo $sum;

answered Mar 5, 2012 at 12:33

Jake

4,4142 gold badges18 silver badges20 bronze badges

Comments

rs. · Accepted Answer · 2012-03-05 12:33:46Z

0

SELECT 
course_code, 
course_title, 
course_unit, 
score, grade, 
(select sum(course_unit) from TableA) total
from TableA;

answered Mar 5, 2012 at 12:33

rs.

27.6k13 gold badges71 silver badges93 bronze badges

Collectives™ on Stack Overflow

How to add a single column php/mysql

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related