[thelist] SQL query by dates

[rudy]

> SELECT
>     TOP 1 LogonDate
> FROM
>     myTable
> GROUP BY
>     ComputerName
> ORDER BY
>     LogonDate DESC

that'll just give one date  ;o)

try this --

select pc_ID, max(LogonDate)
from myTable
group by pc_ID
order by pc_ID


rudy