The Impact of Incorrect Limit Clauses on MySQL Query Performance

Limiting Rows After Ordering: Alternatives to FETCH FIRST in Oracle 11g and Beyond