I have a table of data that contains the following fields:
team, date, time
Some teams run twice a month some only every few months, I need to calculate
a seedings time based on the following:
The fastest time a team ran in it's last 3 outings, however all times
recorded more than 120 days ago is to be ignored.
In Access I created a query to count each team entry and assign a number
1,2,3,4 etc. I then wrote a separate query to query that one and discount
any number over 3 and any date over 120 days.
The 3rd query simply queried the 2nd and returned the fastest time for each
team.
Can anyone think of a way of achieving this in MySQL?
Any help is appreciated
Nige.
team, date, time
Some teams run twice a month some only every few months, I need to calculate
a seedings time based on the following:
The fastest time a team ran in it's last 3 outings, however all times
recorded more than 120 days ago is to be ignored.
In Access I created a query to count each team entry and assign a number
1,2,3,4 etc. I then wrote a separate query to query that one and discount
any number over 3 and any date over 120 days.
The 3rd query simply queried the 2nd and returned the fastest time for each
team.
Can anyone think of a way of achieving this in MySQL?
Any help is appreciated
Nige.