mercredi 13 novembre 2019

Need help converting sql query into laravel query

I need the following sql query into laravel query or how can I run into laravel as it is. thanks

SELECT t.* FROM (select client_id,product_name, max(real_date) as max_date from api_hilbertis.transactions where active = 1 and real_date <= '2019-03-01' group by client_id, product_name) as m inner join api_hilbertis.transactions as t on t.client_id = m.client_id and t.product_name = m.product_name and t.real_date = m.max_date and active = 1 order by real_date desc;``



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire