mysql> select UID,ucount from (select UID,count(ID) as ucount fro m article group by UID having ucount>5) as TABLE1; +-----------+--------+ | UID | ucount | +-----------+--------+ | 10 | 8 | +-----------+--------+ 1 row in set (0.00 sec)这在第一条刮号里面的语句就过滤了绝大部分结果,效率不可同日而语。
m article group by UID having ucount>5) as TABLE1;
+-----------+--------+
| UID | ucount |
+-----------+--------+
| 10 | 8 |
+-----------+--------+
1 row in set (0.00 sec)这在第一条刮号里面的语句就过滤了绝大部分结果,效率不可同日而语。
Clayborne好人品!