More comprehensive query table after a virtual table, but to check personal ranking, real-time data quantity is large, again want to with a view to speed up the query, according to the example of online query with line number can be successful, but the view is not allowed to have variable, ever encounter a situation such as the great god, and to provide the solution
CodePudding user response: