jjzjj

Mysql:按值频率对行进行排序

假设我有这张表:+----+------+---------+|Id|Item|Country|+----+------+---------+|1|b123|Austria||2|a123|Italy||3|b990|Germany||4|h231|Austria||5|y233|France||6|u223|Austria||7|p022|Spain||8|d133|Italy||9|w112|Germany||10|j991|Austria|+----+------+---------+我想对该表执行SELECT操作,并对Country重复次数最多的结果进行排序。所以预期的输出应该