Breaking News: Grepper is joining You.com. Read the official announcement!

Using Having Raw in query builder laravel

Add Answer

Young Master answered on November 15, 2021 Popularity 9/10 Helpfulness 3/10

answer Using Having Raw in query builder laravel

related laravel select raw where

related laravel Raw query methods

related Laravel - Query Builder Raw Query selectRaw

related laravel select raw

Using Having Raw in query builder laravel

Comment

having is used where aggregate functions are within the where clause

$orders = DB::table('orders')
                ->select('department', DB::raw('SUM(price) as total_sales'))
                ->groupBy('department')
                ->havingRaw('SUM(price) > ?', [2500])
                ->get();

Popularity 9/10 Helpfulness 3/10 Language sql

Source: laravel.com

Tags: having laravel query-builder raw sql using

Link to this answer
Share Copy Link

Contributed on May 25 2023

Young Master

0 Answers Avg Quality 2/10

Closely Related Answers

laravel select raw where

Comment

 User::query()
                ->where('users.ban', '!=', 1)
                ->where('users.rights', '=', 1)
                ->leftJoin('users as referal', 'users.id', '=', 'referal.ref_id')
                ->whereNotNull('referal.id')
                ->select([
                    'users.id',
                    'users.name',
                    'users.telegram_id',
                    DB::raw('count(referal.id) as total_referal'),
                    DB::raw("(SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus = 1) as active_referal"),
                    DB::raw("(SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus != 1) as no_active_referal"),
                    DB::raw("((SELECT COUNT(ac_r.id) FROM users as ac_r WHERE ac_r.ref_id=users.id AND ac_r.ref_bonus = 1) * ".User::REFERAL_BONUS.") as total_money_referal"),
                ])
                ->groupBy('users.id')
   ->orderByDesc('total_referal')->paginate(100);

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Oct 09 2022

Shadow

0 Answers Avg Quality 2/10

laravel Raw query methods

Comment

// whereRaw
$orders = DB::table('orders')
    ->whereRaw('price > IF(state = "TX", ?, 100)', [200])
    ->get();
// havingRaw
Product::groupBy('category_id')->havingRaw('COUNT(*) > 1')->get();
// orderByRaw
User::where('created_at', '>', '2016-01-01')
  ->orderByRaw('(updated_at - created_at) desc')
  ->get();

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Sep 16 2022

Itchy Iguana

0 Answers Avg Quality 2/10

Laravel - Query Builder Raw Query selectRaw

Comment

 $totalUsers = MyInventoryModel::selectRaw('pos_inventory.id as pos_inventory_id,pos_products.*,pos_products.product_name as product_name,pos_inventory.reorder_point,pos_inventory.reorder_qty,pos_inventory.current_stock,
                       pos_inventory.variant_id,pos_products.product_sku,pos_product_variants.combination_names,pos_product_variants.sku,pos_outlets.*,pos_roles.*')
                ->leftJoin('pos_products', 'pos_inventory.product_id', '=', 'pos_products.id')
                ->leftJoin('pos_product_variants', 'pos_inventory.product_id', '=', 'pos_product_variants.id')
                ->leftjoin('pos_outlets', 'pos_inventory.outlet_id', '=', 'pos_outlets.id')
                ->leftjoin('pos_roles', 'pos_outlets.store_id', '=', 'pos_roles.store_id')
                ->where('outlet_id', $item->outlet_id)
                ->groupBy('pos_inventory.product_id')
                ->get();

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Nov 15 2021

Fani385

0 Answers Avg Quality 2/10

laravel select raw

Comment

DB::table('some_table')
    ->selectRaw('COUNT(*) AS result')
    ->get();

Popularity 8/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Nov 23 2023

Shadow

0 Answers Avg Quality 2/10

Using Having Raw in query builder laravel

Contents

More Related Answers

Using Having Raw in query builder laravel

Closely Related Answers

laravel select raw where

laravel Raw query methods

Laravel - Query Builder Raw Query selectRaw

laravel select raw

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.