Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. select extract(year from fecha_creacion) as anio, extract(month from fecha_creacion) as mes,
  2. sum(case when tipo = 'entrada' then 1 else 0 end )
  3. from documento
  4. group by extract(year from fecha_creacion), extract(month from fecha_creacion)
  5. order by anio, mes;
  6.  
  7. $data = DB::table('documento')
  8. ->selectRaw('year from fecha_creacion AS anio, month from fecha_creacion AS mes')
  9. ->sum(case when tipo = 'entrada' then 1 else 0 end )
  10. ->orderBy(anio, mes, DESC)
  11. ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement