Re: Embedded sql how to test for no lines

[Jonathan Ball <jonball52@xxxxxxxxx>]

On 8/28/2024 1:48 AM, Birgitta Hauser wrote:
> SELECT DISTINCT is a grouping, i.e. costs additional performance.
> Just a simple SELECT to read the first row that machtes the search criteria
> is the best solution!!!
Correct. You should not use COUNT() as an existence test. You should only use 
COUNT() if one non-zero value has a different meaning in terms of business logic 
than another non-zero value. If all you want to know is if there is at least one 
row, then do SELECT...LIMIT 1. If you get a return value, you do one thing; if 
not, you do something else.