Subject RE: [firebird-support] Check for existence of at least 1 record in result set
Author Leyne, Sean

> Is a SELECT FIRST 1 the solution? Or is there something else which is
> better?

You really want to use the EXISTS predicate.

SELECT FIRST n does not stop at the first row encountered, but resolves
the filter and then returns the first n rows.