Special price product in product collection magento2

[arunsomanhere]

How do I get products with special price rule (for logged in customer group as well as overall) in product collection?

[Store_Manager]

Hello.

If you want to offer different pricing per customer group in Magento 2, you can take advantage of Advanced Pricing tab. In Magento 2 tier&group price functionality is merged together, so there you can apply various prices per customer group.

[arunsomanhere · Accepted solution]

Thanks for the reply but I was trying to setup a separate page contatining list of all products with sepcial prices, I achieved it using the foll:

$collection->addFinalPrice()
->addMinimalPrice()
->getSelect()
->where('price_index.final_price < price_index.price');

Thanks