Limit clauses can be used to specify the begginning offset and ending offset for a search in select(), update(), and delete(). But make note that in delete(), only the begginning offset is taken into account. A limit clause is an array in the following format

     array($startOffset, $endOffset)