Server side development
> Counting Numbers in Column
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?
09-14-2005, 05:19 PM
SELECT SUM(Age) as sumofages, COUNT(age) as numofages FROM table
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.