[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