Ruby on Rails query limit in a range -

Ruby on Rails query limit in a range -

i'm new ruby on rails, , want larn basics of how database works.

i created table named users 3 columns, username, password, email, , have 3 records inside. made query:

@user = users.select(:username).limit(2)

which works.

now want create query like:

select username users limit 1,2

which means:

select 2 username column table users starts @ index 1

like normal mysql query.

i tried

@user = users.select(:username).limit(1,2)

but it's not working. don't know search situation. tried limit query range or limit 1 index query neither works.

i think i'm going need printing out products pages navigation.

i believe need utilize .offset(1)

@user = users.select(:username).limit(2).offset(1)

ruby-on-rails ruby limit