CODE EXAMPLE FOR PHP

limit query codeiniter 3

$this->db->limit(10, 20);  
# Produces: LIMIT 20, 10 (in MySQL.  Other databases have slightly different syntax)