laravel query with order by code example
Example 1: laravel order by
$users = DB::table('users')
-> orderBy('name', 'desc')
-> get();
Example 2: laravel order by raw
$orders = DB::table('orders')
->orderByRaw('updated_at - created_at DESC')
->get();
Example 3: laravel wher in
$users = DB::table('users')
->whereIn('id', [1, 2, 3])
->get();
Example 4: laravel having
$users = DB::table('users')
->groupBy('account_id')
->having('account_id', '>', 100)
->get();