Laravel +postgresql groupby query

I have Model Called "Package". I want to use "SELECT * FROM package WHERE type='domestic' GROUP BY state" query with Laravel postgresql . How can i write this query using "Package" Model.

Dry7

8 years ago

Best Answer

Level 36

@imtiyaz004

Package::where('type', 'domestic')->groupBy('state')
but the original query is incorrect, it is worth writing

Package::select('state')->where('type', 'domestic')->groupBy('state')

1 like

Please or to participate in this conversation.