laravel select subquery

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

showing results for - "laravel select subquery"

11AVG(SUM(amount))

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();

queries leading to this page

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