| Subject | RE: [firebird-support] Check for existence of at least 1 record in result set |
|---|---|
| Author | Leyne, Sean |
| Post date | 2007-02-08T00:10:15Z |
Stefan,
SELECT FIRST n does not stop at the first row encountered, but resolves
the filter and then returns the first n rows.
Sean
> Is a SELECT FIRST 1 the solution? Or is there something else which isYou really want to use the EXISTS predicate.
> better?
SELECT FIRST n does not stop at the first row encountered, but resolves
the filter and then returns the first n rows.
Sean