subquery in laravel

Solutions on MaxInterview for subquery in laravel by the best coders in the world

showing results for - "subquery in laravel"

1In addition to @delmadord's answer and your comments:
2
3Currently there is no method to create subquery in FROM clause, so you need to manually use raw statement, then, if necessary, you will merge all the bindings:
4
5$sub = Abc::where(..)->groupBy(..); // Eloquent Builder instance
6
7$count = DB::table( DB::raw("({$sub->toSql()}) as sub") )
8    ->mergeBindings($sub->getQuery()) // you need to get underlying Query Builder
9    ->count();
10Mind that you need to merge bindings in correct order. If you have other bound clauses, you must put them after mergeBindings:
11
12$count = DB::table( DB::raw("({$sub->toSql()}) as sub") )
13
14    // ->where(..) wrong
15
16    ->mergeBindings($sub->getQuery()) // you need to get underlying Query Builder
17
18    // ->where(..) correct
19
20    ->count();

11AVG(SUM(amount))

similar questions

left join laravel laravel having between laravel range query laravel where and blade laravel php artisan make 3acontroller in subfolder laravel and subdomain php laravel string substring laravel query child relation laravel 2 queries similar reuse code get where different laravel laravel get subdomain subscribe function laravel return view inside subfolder laravel laravel having laravel subtract date laravel description substring

queries leading to this page

subquery in eloquent laravel select query laravel with sub table laravel select table on subquery laravel wherein subquery how to make subquery in select statement laravel subquery in select method laravel laravel query builder subquery eloquent subquery select subquery in select statement laravel subquey in laravel eloquent select subquery subquery select laravel query builder laravel where subquery eloquent subquery where subqueries laravel subquery in laravel in select select query conatins subquery in laravel laravel select inside subquery subqueries in laravel laravel select subquery laravel sql subquery laravel subquery in where select from subquery laravel sub query in laraval laravel eloquent select subquery script select sub categories laravel use subquery with select in laravel laravel select from sub subquery in where clause laravel subquery in db select method laravel laravel subquery with subquery in select laravel laravel sub query in slect laravel subquery laravel with subquery laravel subquery from with subquery laravel laravel sub query select subquery in laravel eloquent subquery select laravel sub query in laravel sub select query laravel laravel subqueries subselect laravel laravel eloquent from subquery laravel subquery select laravel subquery in select laravel subquery use laravel from subquery select laravel eloquent subquery subquery in laravel eloquent laravel subquery laravel subquery where how to write subquery in laravel select laravel subselect sub query laravel laravel eloquent subquery select write sub query in laravel select subquery in where laravel how to subquery in laravel laravel from subquery laravel select from subquery subquery in laravel eloquent subquery in sql laravel how to use sub queries in laravel laravel create subquery query from sub laravel where query laravel subquery sub query in laravel eloquent subquery laravel sub queries laravel laravel select subquery query builder how to write subquery in subquery in laravel 8 eloquent elequoent subquery laravel laravel query where in subquery subquery laravel elquent subquery laravel eloquent eloquent subquery where subquery laravel subquery in select statement eloquent laravel laravel subquery in from laravel subquery example laravel select result from subquery laravel sub select subquery in laravel