查询出每个user_id出现的次数:
SELECT user_id, COUNT(user_id) AS cc FROM USER
GROUP BY user_id
我现在想要做的是查询出 cc>1 的用户情况,不知道怎么写
my god...
SELECT user_id, COUNT(*) AS cc FROM USER GROUP BY user_id having cc>1;
查询出每个user_id出现的次数:
SELECT user_id, COUNT(user_id) AS cc FROM USER
GROUP BY user_id
我现在想要做的是查询出 cc>1 的用户情况,不知道怎么写
my god...
SELECT user_id, COUNT(*) AS cc FROM USER GROUP BY user_id having cc>1;