SQL Server：使这个排名变得高效

I have the following query to pull a customer's most recent purchase. I tried to use a subselect for performance reasons, but I ran into a wall and kept getting back ALL the customers' orders. I just need the most recent for each individual customer. I have the following query to pull a customer's