Strange behavior of TOP 1 clause sql server
But the data in your order by clause doesn't provide any ordering
verification_code is null
and all values for
created_date are the same
you have to give the engine a little bit to work with