...

View Full Version : Counting Numbers in Column



adrian5
09-14-2005, 06: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:

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum