How can I perform the following query with Query Builder Laravel 5.5

Question

How can I perform the following query with Query Builder Laravel 5.5

Navigation

#1 by (1 votes)

0

I have the following query in mysql.

 SELECT COUNT(*) FROM (select SUM(tabla1.campo1) from 'tabla1' inner
 join 'tabla2' on 'tabla1'.'tabla1_id' = 'tabla2'.'tabla2_id' where
'tabla1'.'campo1' <> 0 group by LOWER(tabla1.campo2)) tabla_general

How can I transcribe it to Query Builder in Laravel 5.5? Thanks.

mysql php laravel-5

asked by Edgar García 24.05.2018 в 18:42

source

1 answer

Generate model for the response of an api Validate if there is an id in the database, if there is an update and if there is no insertion to do it - PHP and postgresql

score 1 · Accepted Answer

You can try something like this:

$total = DB::table('tabla1')->selectRaw('SUM(tabla1.campo1), LOWER(tabla1.campo2)')
  ->join('tabla2', 'tabla1.tabla1_id', '=', 'tabla2.tabla2_id')
  ->where('tabla1.campo1', '<>', 0)
  ->groupBy('tabla1.campo2')
  ->count();