Jump to content

Archived

This topic is now archived and is closed to further replies.

DanielStead

calcuate the total number from a particular column

Recommended Posts

hi can anyone suggest a link or a method to how i would do this?

 

I want to do an sql statement that selects say for example the column pages and adds up all the pages in the column for example

 

id pages

1 2

2 4

3 8

4 10

 

The total number of pages should then be 24 (2+4+8+10)

 

anyone got any ideas seems simple but cant find anywhere that tells me how to do it

Share this post


Link to post
Share on other sites

Try using the SUM() function:

 

SELECT SUM(pages) FROM pages_table

 

Hope that helps.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.