How to select data from a sub query using laravel query builder

Question

The code below is not working.

$subQuery = DB::table('table1')->groupBy('col');

$data = DB::table($subQuery, 'sub')->get();

Can you help me with this?

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Mar 4, 2022 at 15:25

IGP · Accepted Answer · 2022-03-04 18:00:34Z

5

Your code is already functional. The only alternative (to make the same query) is to inline the $subQuery part.

$subQuery = DB::table('table1')->groupBy('col');

$data = DB::table($subQuery, 'sub')->get();

Is the same as

$data = DB::table(function ($sub) {
        $sub->from('table1')
            ->groupBy('col');
    }, 'sub')
    ->get();

or

$data = DB::table(DB::table('table1')->groupBy('col'), 'sub')->get();

answered Mar 4, 2022 at 15:29

IGP

16.4k5 gold badges34 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1