how to write this sql with active record

@venance,

Have you considered using something like Datatables (https://datatables.net/)? Then you don't have to worry about pageination.

Or you could create a variable that holds the range of records and whenever the query is run it only pulls the next set of records based on the variables value.