Sql query problem

Sql query results can not be fully displayed.

I cannot find the issue, but I don’t think variables are supported. Workaround is to use a View or ROW_NUMBER()

Can you help me write an example of mysql5.7 query ranking?

I don’t think you can do that on 5.7 without using variables, so your only solution is to use a View.