Try this one for size:
select *
from hardone h1
where not exists (
select 1
from hardone h2
where h2.gmt_event > h1.gmt_event)
BTW, there is a database list for Delphi database/SQL specific questions:
[EMAIL PROTECTED]
Mail listserv with "subscribe database" in the body.
Cheers,
Carl
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
