Subject Re: [ib-support] DISTINCT
Author Claudio Valderrama C.
"Nando Dessena" <nandod@...> wrote in message
> Mike,
> > what I am wanting to do is just get the first record that matches a
> then I don't think that DISTINCT will be of any help.
> If I remember well you are using the latest Firebird; if this is the
> case, you can try TOP (or was it FIRST?).

The last time I checked, it was FIRST, coupled with SKIP.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing