SELECT COUNT(*) FROM (SELECT COUNT(id),order_type,city_id,category_id,major_category_id,puid,user_id
FROM sticky_order
GROUP BY order_type,city_id,category_id,major_category_id,puid,user_id
HAVING COUNT(id) > 1) A
原文：http://www.cnblogs.com/usa007lhy/p/4228771.html