How to make a sub query with Eloquent

I would like to create a query like this with eloquent but is it possible?

SELECT 
    customerNumber, checkNumber, amount
FROM
    payments
WHERE
    amount = (SELECT 
            MAX(amount)
        FROM
            payments
        WHERE
             amount > 50);

bobbybouwmann

7 years ago

Level 88

You can use a raw query for that! So in your case something like this

Payment::whereRaw('select MAX(amount) from payments where amount > 50')->get();

Documentation: https://laravel.com/docs/5.8/queries#raw-expressions

For some more context: https://laravel.com/docs/5.8/queries#where-exists-clauses Note that this works for all methods like whereIn and so on. You can just pass in a callback and perform some query there

Nakov

7 years ago

Level 73

You can do it like this:

Payment::select('customerNumber, checkNumber, amount))
       ->havingRaw('max(amount) > ?', [50])
       ->get();

Please or to participate in this conversation.