SELECT COUNT(*) vs. SELECT SINGLE COUNT(*)
I simply want to check if at least one records of given where-clause already exists. Is there a difference between above mentioned statements?
Siegfried Boes replied
the correct solution is SELECT f1 UP TO 1 ROWS !!!!
You should not use COUNT(*), at least on some databases it will count all records fulfilling the condition.
YOU should not use SINGLE, because ... search top entries there are endless discussion on UP TO 1 ROWS and SINGLE