select count(*) as c from ( select distinct memberid ,createtime from 订单表A ) as a where c>1orselect memberid, count(*) as c from ( select distinct memberid ,createtime from 订单表A ) as a where c>1 or select distinct memberid, count(*) as c from ( select distinct memberid ,createtime from 订单表A ) as a where c>1
select memberid , count(distinct(createtime)) from 订单表A group by memberid having count(memberid ) > 1
哦,漏了一点 createtime需要转成112格式,就是天的了 select memberid , count(distinct(convert(varchar(100), createtime,112))) from 订单表A group by memberid having count(memberid ) > 1
select memberid , count(distinct(createtime)) from 订单表A group by memberid having count(memberid ) > 1
from (
select distinct memberid ,createtime from 订单表A
) as a where c>1orselect memberid, count(*) as c
from (
select distinct memberid ,createtime from 订单表A
) as a where c>1
or select distinct memberid, count(*) as c
from (
select distinct memberid ,createtime from 订单表A
) as a where c>1
from 订单表A
group by memberid
having count(memberid ) > 1
select memberid , count(distinct(convert(varchar(100), createtime,112)))
from 订单表A
group by memberid
having count(memberid ) > 1
from 订单表A
group by memberid
having count(memberid ) > 1