Yeah I had recieved different record set then the usual but only once in prodution.

This scenario is not reproducible there after 🙁

Thanks to all for the reply.

I got the solution to the existing solution.

by Adding the Order by Clause to the existing query.

I am curious to know about if TOP gets...

That is what the expected behavior I am expecting but in the execution plan it show that Distinct block returns fewer records than the one in the table(it is...