Forum Count number of times link_id occurs on pivot table, and sort by highest number of occurences

posted 7 years ago

Database Eloquent

Last updated 2 years ago.

replied 7 years ago

in sql query you can use count() aggregate and order by that column

select count(link_id)
from link_user
order by count(link_id) desc

not sure how to do it using eloquent but you can try this

return DB::table('link_user')
->select(DB::raw('count(link_id)')
->orderBy(DB::raw('count(link_id)')
->get();

returnvalue returnvalue Joined 19 Mar 2015

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community