[thelist] SQL query by dates

Ken Schaefer ken at adOpenStatic.com
Sat Sep 27 21:52:56 CDT 2003


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

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Michael Porter" <porterm at eircom.net>
Subject: [thelist] SQL query by dates


I need to find when each pc last logged on, extracting pc_ID, and Date from
a tble containing records of log ons over a number of years. Is this
possible to do in one query?

Regards
Mick
-- 
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !



More information about the thelist mailing list