id = v.levelid
and h.gmt_event = v.gmt_event order by h.levelid, h.gmt_event
I haven't even thought about testing it so no promises.
Max
THanks
Mike
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Carl Reynolds
> Sent: Friday, 1 S
ptember 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 &
ECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mike Mueller
Sent: Friday, 1 September 2000 08:56
To: Multiple recipients of list delphi
Subject: [DUG]: Question on style for you SQL Gurus
I have an SQL query that I'm trying to get to work as fast as possible. My
initial version worked fine, but wa
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
I have an SQL query that I'm trying to get to work as fast as possible. My
initial version worked fine, but was doggedly slow because it had a 'select'
as one of the 'where' conditions. (which makes it an n-squared operation I
believe). I managed to get it to work a million times faster (ie. or
