View Full Version : Counting Numbers in Column

09-14-2005, 05:14 PM
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 :thumbsup:

09-14-2005, 05:19 PM
SELECT SUM(Age) as sumofages, COUNT(age) as numofages FROM table

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum