I have a user database where a year has to be put in.
Now, I want to compile a list of each different year and how many users are in that
year.
Is there a way to do this beyond coding for each year:
SELECT * FROM students WHERE year = '1983' ?
- Kath
You could try something like this:
SELECT year, count(studentID) FROM students GROUP BY year
...where studentID is the primary key column/field in your students table.
Josh Hoover
KnowledgeStorm, Inc.
Searching for a new IT solution for your company? Need to improve your
product marketing?
select count(*), year from students group by year;
on 3/1/01 12:07 PM, Kath at [EMAIL PROTECTED] wrote:
I have a user database where a year has to be put in.
Now, I want to compile a list of each different year and how many users are in
that year.
Is there a way to do this beyond
3 matches
Mail list logo