method

offset

v5.2.3 - Show latest stable - 1 note - 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")

Show source

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

October 22, 2010

1 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)