Jump to content


Count numbers in column

Started by _*adrian_*, Sep 14 2005 11:11 AM

1 reply to this topic

#1 _*adrian_*

  • Guests

Posted 14 September 2005 - 11:11 AM

OK. Say i have three columns. ID, NAME, AGE. I want to count all the ages in the AGE column and add them up. How?

Thanks

#2 Jamie Huskisson

    Retired P2L Staff

  • Members
  • PipPipPipPip
  • 3,648 posts
  • Gender:Male
  • Location:Nottingham, UK

Posted 14 September 2005 - 11:50 AM

select SUM(age) as age_total from table..

or add SUM(age) as age_total in the middle of your other columns your selecting to get the total of just that partitular query
Back to Programming and General Web Design · Next Unread Topic →


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

  1. Pixel2Life Forum
  2. → Help Section
  3. → Programming and General Web Design