SELECT SUM(CONS_PAYMONEY) as tmoney,COUNT(DISTINCT CONS_MEMID) as tuser,count(1) as tnum FROM `ks_user_cost` WHERE () LIMIT 1
我要查询CONS_MEMID字段相同值出现的次数,取次数大于3的。
不用group by
在where里面如何写查询条件,请大虾指教
我要查询CONS_MEMID字段相同值出现的次数,取次数大于3的。
不用group by
在where里面如何写查询条件,请大虾指教
SELECT SUM(CONS_PAYMONEY) as tmoney,COUNT(DISTINCT CONS_MEMID) as tuser,count(1) as tnum FROM `ks_user_cost` group by id having COUNT(DISTINCT CONS_MEMID)>=3
or
select * from (
SELECT SUM(CONS_PAYMONEY) as tmoney,COUNT(DISTINCT CONS_MEMID) as tuser,count(1) as tnum FROM `ks_user_cost` ) a WHERE tuser>=3 LIMIT 1
不是这个意思
CONS_MEMID记录的是一个用户id。
即选择在这个表里面有3条记录以上的用户。