@@ -123,14 +123,14 @@ |
||
123 | 123 | $users = DB::table("users as u") |
124 | 124 | ->selectRaw("u . id as usuario, sub . street as rua") |
125 | 125 | ->leftJoinSub($address, 'sub', "sub . user_id = u.id AND 1 = ?", [1]); |
126 | -var_dump($users->get());die; |
|
126 | +var_dump($users->get()); die; |
|
127 | 127 | |
128 | 128 | /** |
129 | 129 | * Selecionar de uma subquery |
130 | 130 | * |
131 | 131 | * Select * from (select * from users) as sub |
132 | 132 | */ |
133 | -$dados = DB::fromSub(function (Query $query) { |
|
133 | +$dados = DB::fromSub(function(Query $query) { |
|
134 | 134 | return $query->from("users")->selectRaw('first_name')->limit(10); |
135 | 135 | }, 'sub') |
136 | 136 | ->order('first_name')->groupBy(['first_name']); |