variable for patient age

[CCleveland]

I am trying to write a query to sort by patient's age. What is the relevant variable to use.

[Jorgebon]

The patient's age is probably the result of a calculation based on the patient's birth date. You can find that in the Patient table. If you tell us what you would like we can probably help you write the query. This is the simplest way to sort by age:

select * from patient
Order by birthdate

Jorge Bonilla, DMD

[CCleveland]

Jorge,

I am trying to determine the age distribution of my patients, by year. Do you know of a useful how-to guide for SQL queries?

Thanks

[Jorgebon]

I like "Teach Yourself SQL in Ten Minutes" by Ben Forta. I got it at Border's. So what you want could be something like a total number of patients within a range. For example, a list and total number of patients under the age of ten. I think the way to keep it simple is to have one query for each age range. Let me see if I can come up with something.
Jorge Bonilla, DMD

[jordansparks]

I threw this query together.

SELECT YEAR(CURDATE())-YEAR(BirthDate) Age,COUNT(*) FROM patient
WHERE BirthDate>'1800'
AND BirthDate <= CURDATE()
AND PatStatus !=4
GROUP BY Age

It works really well, but it doesn't take into account the month or day a patient was born, just the year they were born. That's probably close enough, though.

[Jorgebon]

Hey that's really cool !!
You can then export those numbers as an Excel file and make a graph. That's a little different from what I was thinking, since I was thinking CCleveland wanted a list of patient names.
Jorge Bonilla, DMD