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 we audit devices daily on a s
