Levelup

🕵️‍♀️ Task

Select all records from the movies table, except the first 10 records.

movies

id (integer)
title (string)
year (integer)
duration (integer)
description (text)
image (string)
director_id (integer)

directors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

actors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

characters

id (integer)
actor_id (integer)
movie_id (integer)
name (string)

📖Method

You can skip some records in the ActiveRecord::Relation set with .offset. This is useful for e.g. retrieving the second page of records, or choosing a random record.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image
348	Denholm Elliott	1922-05-31	Much-loved character actor ...	http://ia.media-imdb.com/im...
373	Lionel Barrymore	1878-04-28	Famed actor, composer, arti...	http://ia.media-imdb.com/im...
343	Christine Estabrook	1952-09-13	Veteran actress Christine E...	http://ia.media-imdb.com/im...
344	Karen Allen	1951-10-05	Born in rural southern Illi...	http://ia.media-imdb.com/im...
345	Paul Freeman	1943-01-18	One of Britain's most versa...	http://ia.media-imdb.com/im...
346	Ronald Lacey	1935-09-28	Ronald Lacey was born on Ju...
347	John Rhys-Davies	1944-05-05	Acclaimed British actor Joh...	http://ia.media-imdb.com/im...
370	Irene Winston	1916-07-18

Data

id	actor_id	movie_id	name
344	92	24	Frank
345	307	24	Cheyenne
346	308	24	Harmonica
347	309	24	Morton - Railroad Baron
348	310	24	Sam
349	311	24	Stony - Member of Frank's Gang
350	312	24	Snaky - Member of Frank's Gang
351	313	24	Sheriff - Auctioneer

Examples

Select all records from the persons table, EXCEPT the first 2 records

people = Person.all.where({ :current_city => "Chicago"})

people.offset(2)
=> #<Person::ActiveRecord_Relation:0x00007fa4341e1ee8>

Select all records from the dishes table, EXCEPT the first 20 records

Dish.all.offset(20)
=> #<Dish::ActiveRecord_Relation:0x00007fa4341e1ee8>