-Original Message-
From: Daevid Vincent
Sent: Friday, February 11, 2005 14:32
To: mysql@lists.mysql.com
Subject: Need help with historic aggregation of data
I need to get the aggregate data from various tables for a report.
The idea is that we audit devices daily on a schedule,
select test, max(audit_date)
from your_table
where device = 1
group by test
order by 1
--- Daevid Vincent [EMAIL PROTECTED] wrote:
I need to get the aggregate data from various tables
for a report.
The idea is that we audit devices daily on a
schedule, and also allow users
to audit the
