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