Subject Re: Check for existence of at least 1 record in result set
Author Milan Babuskov
--- Stefan Heymann wrote:
> What is the best and least costly way to check for the existence of at
> least one record in the result set of a SELECT?

I'm but sure about FIRST, but this should do it:

select 1 from rdb$database
where exists ( INSERT_YOUR_SELECT_HERE );


Milan Babuskov