Problems with translation of query to eloquen

How about, I tried to translate this query sql to eloquen, but I do not achieve it, does anyone know how I can do it?

SELECT COUNT(nombre), usuario_ad FROM usuarios GROUP BY usuario_ad ORDER BY COUNT(nombre) desc;

regal2157

7 years ago

Best Answer

Level 5

DB::table('usuarios')
    ->select('usuario_id', DB::raw('count(nombre) as nombre')
    ->group_by('usuario_ad')
    ->order_by('nombre', 'desc')
    ->get();

I didn't test it, but something like that?

daniel21gt

7 years ago

Level 1

Yes regal2157, thanks very much

Please or to participate in this conversation.