I was searching for making a GROUP BY name Eloquent ORM docs but I haven t find anything neither on google Does anyone know if it s possible or should I use query builder

try - gt unique column example users User get - gt unique column

Eloquent uses the query builder internally so you can do users User orderBy name desc - gt groupBy count - gt having count gt 100 - gt get

Laravel 5 This is working for me i use laravel 5 6 collection MyModel all - gt groupBy column If you want to convert the collection to plain php array you can use toArray array MyModel all - gt groupBy column - gt toArray

[laravel] Group By Eloquent ORM

try: ->unique('column')

example:

$users = User::get()->unique('column');

Examples related to laravel

• Parameter binding on left joins with array in Laravel Query Builder • Laravel 4 with Sentry 2 add user to a group on Registration • Target class controller does not exist - Laravel 8 • Visual Studio Code PHP Intelephense Keep Showing Not Necessary Error • The POST method is not supported for this route. Supported methods: GET, HEAD. Laravel • How to fix 'Unchecked runtime.lastError: The message port closed before a response was received' chrome issue? • Post request in Laravel - Error - 419 Sorry, your session/ 419 your page has expired • Expected response code 250 but got code "530", with message "530 5.7.1 Authentication required • How can I run specific migration in laravel • Laravel 5 show ErrorException file_put_contents failed to open stream: No such file or directory

Examples related to group-by

• SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by • Count unique values using pandas groupby • Pandas group-by and sum • Count unique values with pandas per groups • Group dataframe and get sum AND count? • Error related to only_full_group_by when executing a query in MySql • Pandas sum by groupby, but exclude certain columns • Using DISTINCT along with GROUP BY in SQL Server • Python Pandas : group by in group by and average? • How do I create a new column from the output of pandas groupby().sum()?

Examples related to laravel-4

• Parameter binding on left joins with array in Laravel Query Builder • Laravel 4 with Sentry 2 add user to a group on Registration • 'Malformed UTF-8 characters, possibly incorrectly encoded' in Laravel • Can I do Model->where('id', ARRAY) multiple where conditions? • how to fix stream_socket_enable_crypto(): SSL operation failed with code 1 • Rollback one specific migration in Laravel • How can I resolve "Your requirements could not be resolved to an installable set of packages" error? • Define the selected option with the old input in Laravel / Blade • Redirect to external URL with return in laravel • laravel the requested url was not found on this server

Examples related to eloquent

• Eloquent: find() and where() usage laravel • How to select specific columns in laravel eloquent • Laravel Eloquent where field is X or null • Laravel Eloquent limit and offset • laravel collection to array • Eloquent get only one column as an array • Laravel 5.2 - Use a String as a Custom Primary Key for Eloquent Table becomes 0 • Laravel 5.2 - pluck() method returns array • Eloquent ORM laravel 5 Get Array of ids • eloquent laravel: How to get a row count from a ->get()