method

add_limit_offset!

v1.2.6 - Show latest stable - Class: ActiveRecord::ConnectionAdapters::DatabaseStatements

add_limit_offset!(sql, options)

public

Appends LIMIT and OFFSET options to a SQL statement. This method modifies the sql parameter.

Examples

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

generates

 SELECT * FROM suppliers LIMIT 10 OFFSET 50

# File activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb, line 93
      def add_limit_offset!(sql, options)
        if limit = options[:limit]
          sql << " LIMIT #{limit}"
          if offset = options[:offset]
            sql << " OFFSET #{offset}"
          end
        end
      end

add_limit_offset!

Examples

Related methods