JDatabaseQuerySqlsrv::setLimit
Sets the offset and limit for the result set, if the database driver supports it.
Usage: $query->setLimit(100, 0); (retrieve 100 rows, starting at first record) $query->setLimit(50, 50); (retrieve 50 rows, starting at 50th record)
Signature
public function setLimit([integer
$limit = 0,
[integer
$offset = 0]] )
Parameters
-
$limit - The limit for the result set
-
$offset - The offset for the result set
Returns
- JDatabaseQuery
- Returns this object to allow chaining.