How can I apply raw query in my Laravel select query? I have two tables in my database one is a product and the second is product_price. I want to list those products whose product price is gathered than zero.
My Code:
select * from `product` where `product_id` IN (select product_id from `product_price` where `price` > 0 GROUP BY product_id)
This MySQL query not working in Laravel. Any solution?
Question and answer is powered by AnsPress.io