Subject Re: [firebird-support] Check constraint error
Author Ann W. Harrison
Rick DeBay wrote:
> Thanks. I'll use DISTINCT or FIRST 1 depending on my mood at the time.

First is cheaper - the system retrieves only one record. Distinct has
the advantage of letting you know if you've made a bad assumption about
your data. Any aggregate function will also work and might be more
reasonable than arbitrarily accepting the first value.