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.

Thank you, I think for this issue a datatable would be the best solution