$books = \App\Book::skip(0)->take(2)->get(); return $books; }); // Skip the first two records and take the next 3 records Route::get('book_skip_and_take_again', function () { $books = \App\Book::skip(2)->take(3)->get(); return $books; }); // Order the books in ascending order according to their title, `desc` is also an alternative Route::get('book_orderBy', function () { $books = \App\Book::orderBy('title', 'asc')->get(); return $books; }); // Group the books by the price...e.g if 3 books have thesame price, it groups them together as one Route::get('book_groupBy', function () { $books = \App\Book::groupBy('price')->get(); return $books; }); // Return all books that have pages_count less than 150 Route::get('book_having', function () { $books = \App\Book::having('pages_count', '<', 150)->get(); return $books; }); // Return all books including the ones that have been deleted // Listen: this requires your migration already has $table->softDeletes(); // and your Model also uses the Eloquent SoftDeletes trait Route::get('all_books_including_those_that_have_been_deleted', function () { $books = \App\Book::withTrashed()->get(); return $books; }); // Return only all the books that have been deleted