SELECT * FROM xsjl WHERE 业务员代码 IN (SELECT 业务员代码 FROM xsjl GROUP BY 业务员代码 HAVING count(*)<80) order by 业务员代码请问各位怎么实现同时查询小于80和大于120
继续加条件就是了 比如:... HAVING count(*)<80 and count(*)>120 ...