issue with "Order by" clause

I have used query hint "OPTION ( HASH GROUP )" and now its working fine.

Thanks for all your help and responses.