Limited SELECT count(*)
A SELECT statement with COUNT returns the number of rows retrieved by the SELECT statement. For performance, the desired result is to limit that count. Including a LIMIT clause in the SELECT statement will not work since it only restricts the number of rows returned, which is always one. The solution, what I call “Limited-Count”, [...]