Very simple use case, when using distinct with pagination on sql server, there are two issues. Row count is incorrect. The sql statement that laravel converted is [select count(*) as aggregate from ...

A SELECT group of programmers with a DISTINCT advantage If you’re still with us, congratulate yourself—you survived the second part of our series on SQL basics!