Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Counting Users Ages

Author  Topic 

BillyWhizz
Starting Member

6 Posts

Posted - 2001-04-27 : 04:33:26
My database stores a date of birth, not an age in the user details table. To get their age, I use datediff. So how do I count how many people are of a certain age, ie 21 years -> 89 users, 22 years -> 122 users etc.

Any help greatly appreciated. My head hurts!

   

- Advertisement -