database, sql query, mysql

hello ,

if your structure is like
TABLE STUDENTS COLUMNS: StudentID (primary key), Name(varchar), Firstname(varchar), Dateofbirth(datetime)

then use this
SELECT FLOOR(DATEDIFF(day,Dateofbirth , GETDATE()) / 365.25) AS AGE, COUNT(*) AS [No of Student] FROM TblEmployee GROUP BY FLOOR(DATEDIFF(day, Dateofbirth, GETDATE()) / 365.25);

hoping it will work for you.

sanjeev

For Calculating number of students of specified age the SQL Query is as :

Select SUM(No_Of_Students) From [table name] Where Age=[Your Specified Age]

And for Calculating number of students below the specified Age :

Select SUM(No_Of_Students) From [table Name] Where (Age=1 OR Age=2 OR Age=3 ... OR Age=[Your specified Age]

Thanks.

my database is of foll fields

st id
name
class
gender
do birth
do leaving school
fee paid (till to date)
group (science / arts)

i have to calculate age first and insert it into a column

than i have to find the age distributions


Thanks everybody for helping me out. Highly obliged

that will make my problem more clear

let it be an employee mgmt system

i have
EID (PK)
Date of birth (datetime)
date of joining (datetime)
date of retirement(datetime)
date of death (date time)


i do not have to calculate age till today but i want to calculate age till date of retirement or date of death(if available)

i want to declare a new column "age" and keep the records of every employee in it

i have a query working for it

select case when not death is null then
datediff(year, birth, death ) 
else datediff(year , birth, date_of_retirement ) end from Table_3

it works ok, but i want to save the results in "age"

better if you share your table structure whatever, please try this qry

Select Age, Count(StudentName)
from table1
Group by Age


thanks