mysql> select pid,count(*) as num1 from netinfo where mt_wid<>'0000' group by pid order by num1; +-------+------+ | pid | num1 | +-------+------+ | 23769 | 14 | | 27866 | 18 | | 55520 | 19 | | 16877 | 26 | | 12345 | 91 | +-------+------+ 5 rows in set (0.00 sec)mysql> select pid,count(*) as num2 from netinfo where mt_wid='0000' group by pid order by num2; Empty set (0.00 sec)
+-------+------+
| pid | num1 |
+-------+------+
| 23769 | 14 |
| 27866 | 18 |
| 55520 | 19 |
| 16877 | 26 |
| 12345 | 91 |
+-------+------+
5 rows in set (0.00 sec)mysql> select pid,count(*) as num2 from netinfo where mt_wid='0000' group by pid order by num2;
Empty set (0.00 sec)