When limit in MySQL is used in conjunction with Max, the query is empty

In general, the use of limit for paging is usually the first page to use the functions of Max and Min to evaluate, this is normal, but if the limit goes to the second page to find that this use is not possible, the reason is unknown!

The modifications are in the following ways, suitable for most:

Select Max  from (Select*from1,1astemp

That is, select makes nested queries.

Efficiency is certainly lower, after all, using a nested query, but nested that statement has been queried memory, so the performance will not be too much difference.

Reference:

Https://stackoverflow.com/questions/1150715/how-can-i-use-max-and-limit-together-in-mysql

Http://www.jianshu.com/p/77226327a3ad

http://bbs.csdn.net/topics/390302875

When limit in MySQL is used in conjunction with Max, the query is empty