Laravel Query Builder: Ordering, Grouping, Limit, & Offset

OrderBy

$users = DB::table('users')
                ->orderBy('name', 'desc')
                ->get();

Latest / oldest

$user = DB::table('users')
                ->latest()
                ->first();

InRandomOrder

$randomUser = DB::table('users')
                ->inRandomOrder()
                ->first();

GroupBy / having

$users = DB::table('users')
                ->groupBy('account_id')
                ->having('account_id', '>', 100)
                ->get();
$users = DB::table('users')
                ->groupBy('first_name', 'status')
                ->having('account_id', '>', 100)
                ->get();

Skip / take

$users = DB::table('users')->skip(10)->take(5)->get();

Limit and offset

$users = DB::table('users')
                ->offset(10)
                ->limit(5)
                ->get();

Laravel Query Builder: Ordering, Grouping, Limit, & Offset — Structure map

Clickable & Draggable!

Laravel Query Builder: Ordering, Grouping, Limit, & Offset — Related pages: