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