Archive for the ‘limit’ Category

Limited SELECT count(*)

Май 14th, 2010
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”, is done [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in Cool MySQL Queries, count, limit, limited count, performance, select

Комментарии отключены