Thanks Phelabaum, this makes sense.

Can one write a similar query through which a query plan can be achieved that ensures the same output being assigned to @variable that is being...

Thanks Jason, you are right removing the Order By will produce the result but not the required/correct result in every case. The query I provided is part of the issue...