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 audi
> -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
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 devices by choosing certain tests to run. It is also the case
that new tests are added daily. So the scheduled test today has more tests
than
