Compare and inquire about the ranking of the competition.

the user guesses the score of a game, which is about

< table > < thead > < tr > < th > id < / th > < th > team1 (home team scores) < / th > < th > team2 (visiting team scores) < / th > < / tr > < / thead > < tbody > < tr > < td > 1 < / td > < td > 1 < / td > < td > 2 < / td > < / tr > < tr > < td > 2 < / td > < td > 4 < / td > < td > 2 < / td > < / tr > < tr > < td > 3 < / td > < td > 3 < / td > < td > 2 < / td > < / tr > < tr > < td > 4 < / td > < td > 5 < / td > < td > 2 < / td > < / tr > < tr > < td > 5 < / td > < td > 3 < / td > < td > 1 < / td > < / tr > < tr > < td > 6 < / td > < td > 1 < / td > < td > 1 < / td > < / tr > < tr > < td > 7 < / td > < td > 3 < / td > < td > 3 < / td > < / tr > < / tbody > < / table >

if the final result is: 3Rom 1, how can the query be sorted according to the correct result?

Sql-statement sql mysql

Mar.18,2021

from your example, do you want the quiz display where the actual ID is 5 ?

Previous: A CAPTCHA appears when the python: code accesses the weixin.sogou.com, but not when the browser is opened

Next: Ask SQL SERVERE how to insert a row of data intermittently, that is, a few fields and then a few fields.