laravel select subquery

In addition to @delmadord's answer and your comments:

Currently 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:

$sub = Abc::where(..)->groupBy(..); // Eloquent Builder instance

$count = DB::table( DB::raw("({$sub->toSql()}) as sub") )
    ->mergeBindings($sub->getQuery()) // you need to get underlying Query Builder
    ->count();
Mind that you need to merge bindings in correct order. If you have other bound clauses, you must put them after mergeBindings:

$count = DB::table( DB::raw("({$sub->toSql()}) as sub") )

    // ->where(..) wrong

    ->mergeBindings($sub->getQuery()) // you need to get underlying Query Builder

    // ->where(..) correct

    ->count();

Add Own solution

Are there any code examples left?

Find Add Code snippet

New code examples in category PHP

PHP 2022-03-27 22:40:03 index:of curiosa 2019 mp4
PHP 2022-03-27 22:35:13 Dijkstra’s algorithm php
PHP 2022-03-27 22:35:12 get_declared_classes
PHP 2022-03-27 22:30:23 php move index of a value to first position in array
PHP 2022-03-27 22:25:01 wordpress get_date
PHP 2022-03-27 21:30:38 php shorten string with dots
PHP 2022-03-27 21:10:46 php header 500
PHP 2022-03-27 21:05:06 laravel schedule run
PHP 2022-03-27 20:25:12 Get page title, excerpt or content by id
PHP 2022-03-27 20:00:27 php convert date from dd/mm/yyyy to yyyy-mm-dd

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

laravel select table on subquery sub query in laraval laravel select subquery query builder laravel create subquery subquery in eloquent laravel laravel from subquery write sub query in laravel select elequoent subquery laravel subquery in select statement eloquent laravel laravel eloquent select subquery subquery in select statement laravel laravel subquery in where laravel select inside subquery select subquery in laravel eloquent subquery in db select method laravel subquery in select method laravel subquery in select laravel laravel subquery use how to use sub queries in laravel sub query in laravel use subquery with select in laravel laravel query where in subquery laravel query builder subquery subquery laravel elquent laravel where subquery subqueries in laravel eloquent select subquery laravel sub select laravel select from sub laravel subquery from laravel subquery in from laravel subquery example subquery in laravel eloquent laravel subqueries laravel subquery where subquery laravel eloquent subquery laravel laravel subquery select sub query laravel laravel sub query where subquery laravel subselect laravel laravel sub query in slect laravel with subquery laravel subSelect laravel subquery eloquent subquery select subquey in laravel subquery in laravel in select subquery in laravel laravel eloquent subquery select laravel select from subquery laravel select subquery

laravel select subquery

Welcome Back!

Create a Free Account