How about:
select h1.*
from hardone h1, hardone h2
where h1.gmt_event > h2.gmt_event
and h1.item = h2.item
group_by h1.item
Again, this hasn't been tested, just ideas.
> -----Original Message-----
> From: Carl Reynolds [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 1 September 2000 9:42 a.m.
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Question on style for you SQL Gurus
>
>
> 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"
>
---------------------------------------------------------------------------
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"
