Add Group By in admin side grid

[ppstech]

How can I add groupby clause to a particular column in grid, so that the data should be grouped and displayed in the same grouped wise.

[rahul]

Hi @ppstech

We can do it using query builder.

$queryBuilder = DB::table('table_name')
        ->select()
        ->groupBy();

Thanks

[ppstech]

hi @rahul ,
I am not talking about the query. I want to show it in grid something like below.

Is there any functionality in grid through which I can achieve it? does the grid support group by feature with drag & drop column? or I need to do it manually