Count values

[karimali831]

Hi

 

Take a look at attatchment.

I want to count all values for "points" column where clanID.

 

clanID = 11 and has 5 points in one row and 5 in another row.

Output = 10 points.

 

clanID = 15 and has 10 points only in one row

Output = 10 points

 

I'm sure you get it.

 

Thanks for any help

 

[attachment deleted by admin]

[Daniel0]

SELECT SUM(points) FROM table WHERE clanID = 11;

 

Or:

SELECT SUM(points) FROM table GROUP BY clanID;

[karimali831]

Great, thanks alot.