, 2001 1:48 AM
To: [EMAIL PROTECTED]
Subject: Query with avg on last 60 entries
I have come up with a bit of a problem which I cant seem to work out...
I have a table that gets updated every minute with data. The table has 3
fields in it... id, date, number
what im trying to do with a single
I have come up with a bit of a problem which I cant seem to work out...
I have a table that gets updated every minute with data. The table has 3
fields in it... id, date, number
what im trying to do with a single query is, select the last 60 records,
and output the average of the number field
w
