method

offset

v5.0.0.1 - Show latest stable - Class: ActiveRecord::QueryMethods

offset(value)

public

Specifies the number of rows to skip before returning rows.

User.offset(10) # generated SQL has "OFFSET 10"

Should be used with order.

User.offset(10).order("name ASC")

# File activerecord/lib/active_record/relation/query_methods.rb, line 728
    def offset(value)
      spawn.offset!(value)
    end

ssoroka · Oct 22, 20101 thank

for some reason this method only works on relation objects, not directly on an AR class.

# doesn't work
User.offset(3).limit(1)

# does work
User.limit(1).offset(3)