Limit sql in CakeFp search function

Question

How can I use the sql limit in cakephp ... I mean that sql ...

select * from emp limit 3,4 

How to use the upper limit [3,4] in the search function ...

Answer 1

The best way: $this->Emp->find('all', array('limit'=>4, 'offset'=>3);

Answer 2

I have not tested it, but there should be something like this in the controller:

 $this->Emp->find('all',array('limit'=>'3,4')); 

Hope this helps