add_limit_offset!(sql, options) public

Appends LIMIT and OFFSET options to an SQL statement, or some SQL fragment that has the same semantics as LIMIT and OFFSET.

options must be a Hash which contains a :limit option (required) and an :offset option (optional).

This method modifies the sql parameter.

 add_limit_offset!('SELECT * FROM suppliers', {:limit => 10, :offset => 50})


 SELECT * FROM suppliers LIMIT 10 OFFSET 50
Show source
Register or log in to add new notes.