@nestlake 既然要用到次数 先 group by 然后 jion 再 order by 可以。
tigiyj
2017-10-20 08:57:52 +08:00
SELECT p1.city, p1.company FROM table1 AS p1 LEFT JOIN ( SELECT city, count(city) AS num FROM table1 GROUP BY city ) AS p2 ON p1.city = p2.city ORDER BY p2.num DESC, p1.company ASC 写的比较糙