Query sql to eloquen laravel 5.5

Navigation
0

Again with my new questions, does anyone know how I can translate this query to eloquent? 

SELECT COUNT(nombre), usuario_ad 
FROM usuarios 
GROUP BY usuario_ad 
ORDER BY COUNT(nombre) desc;
    
asked by zereft 16.12.2018 в 22:12
source

1 answer

0

Solution! 

DB::table('usuarios')
              ->select('usuario_ad', DB::raw('count(nombre) as nombre'))
              ->groupBy('usuario_ad')
              ->orderBy('nombre', 'desc')
              ->paginate(10);
    
answered by 17.12.2018 в 00:17
add column type DateTime Problem to show all json objects related to a model by its id in RoR