To page results in RethinkDB, you’ll want to sort the results, skip to the page you want, and limit the number of rows to the page size:<\/p>\n
r.db('test')\n .table('users')\n .orderBy('last_name')\n .skip(10)\n .limit(10)\n<\/pre>\n <\/p>\n
\nHere is an example result:<\/p>\n
\n\n\n\n\n\n\n<\/td>\n \n\nfirst_name<\/div>\n<\/div>\n<\/td>\n\n\nid<\/div>\n<\/div>\n<\/td>\n\n\nlast_name<\/div>\n<\/div>\n<\/td>\n\n\nuser_name<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n1<\/div>\n<\/td>\n\n\ngary<\/div>\n<\/div>\n<\/td>\n\n\n72b719a2-0a96-4b54-aaba-63b76e5c3c75<\/div>\n<\/div>\n<\/td>\n\n\nsieling<\/div>\n<\/div>\n<\/td>\n\n\ngsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n2<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n\n\ncb93de7e-2d91-48ce-956e-4090694e5cb9<\/div>\n<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n3<\/div>\n<\/td>\n\n\ntest 1<\/div>\n<\/div>\n<\/td>\n\n\n02b2fa2b-7e50-43cc-a476-a14d3b4324ac<\/div>\n<\/div>\n<\/td>\n\n\ntest 1<\/div>\n<\/div>\n<\/td>\n\n\ntest<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n4<\/div>\n<\/td>\n\n\ntest 10<\/div>\n<\/div>\n<\/td>\n\n\nedabe8a9-b77e-4446-97aa-be9b7d542784<\/div>\n<\/div>\n<\/td>\n\n\ntest 10<\/div>\n<\/div>\n<\/td>\n\n\ntest 10<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n5<\/div>\n<\/td>\n\n\ntest 2<\/div>\n<\/div>\n<\/td>\n\n\na86e769d-32fa-4853-9018-f8c360795304<\/div>\n<\/div>\n<\/td>\n\n\ntest 2<\/div>\n<\/div>\n<\/td>\n\n\ntest 2<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n6<\/div>\n<\/td>\n\n\ntest 3<\/div>\n<\/div>\n<\/td>\n\n\nbfff0d26-f1f1-4a07-9bb6-e54302c5ee05<\/div>\n<\/div>\n<\/td>\n\n\ntest 3<\/div>\n<\/div>\n<\/td>\n\n\ntest 3<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n7<\/div>\n<\/td>\n\n\ntest 4<\/div>\n<\/div>\n<\/td>\n\n\nd6c17523-8857-44c4-a014-12ac58764276<\/div>\n<\/div>\n<\/td>\n\n\ntest 4<\/div>\n<\/div>\n<\/td>\n\n\ntest 4<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n8<\/div>\n<\/td>\n\n\ntest 5<\/div>\n<\/div>\n<\/td>\n\n\n3e9345bf-a16b-4bcd-927f-0ff226bf3228<\/div>\n<\/div>\n<\/td>\n\n\ntest 5<\/div>\n<\/div>\n<\/td>\n\n\ntest 5<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n9<\/div>\n<\/td>\n\n\ntest 6<\/div>\n<\/div>\n<\/td>\n\n\na31dd384-cd63-44c8-addd-cb81db15e278<\/div>\n<\/div>\n<\/td>\n\n\ntest 6<\/div>\n<\/div>\n<\/td>\n\n\ntest 6<\/div>\n<\/div>\n<\/td>\n<\/tr>\n\n\n10<\/div>\n<\/td>\n\n\ntest 7<\/div>\n<\/div>\n<\/td>\n\n\nd6503bb3-3e85-464e-9019-5beee03d1d9d<\/div>\n<\/div>\n<\/td>\n\n\ntest 7<\/div>\n<\/div>\n<\/td>\n\n\ntest 7<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"To page results in RethinkDB, you’ll want to sort the results, skip to the page you want, and limit the number of rows to the page size: r.db(‘test’) .table(‘users’) .orderBy(‘last_name’) .skip(10) .limit(10) Here is an example result: 10 rows returned in 167ms. first_name id last_name user_name 1 gary 72b719a2-0a96-4b54-aaba-63b76e5c3c75 sieling gsieling 2 test cb93de7e-2d91-48ce-956e-4090694e5cb9 … <\/p>\n