SQL查询在两个不同的Mysql AWS服务器上的工作方式不同

We have two mysql sql RDS servers and we are facing an issue which i am not able to resolve. The query that we are using is a simple selection of max date row from the data set. This is working fine on the first server, where as this is not working correctly on the other server even on the same data set.We have two mysql sql RDS servers and we are fa