Eng 6436 distinct reroute

This is the fast, simple but not the best efficient solution for DISTINCT with GROUP BY cases. We will create tickets to optimize it later.
As we discussed, test something like: select distinct max(A3) group by PKEY order by B3.