看半天才明白你想要啥结果,看看是这个结果不?
SELECT to_char(creattime, 'yyyy-mm-dd')creattime,count(distinct id),count(1)
from network_checkin
group by to_char(creattime, 'yyyy-mm-dd')
SELECT to_char(creattime, 'yyyy-mm-dd')creattime,count(distinct id),count(1)
from network_checkin
group by to_char(creattime, 'yyyy-mm-dd')
group by to_char(creattime, 'yyyy-mm-dd')
order by to_char(creattime, 'yyyy-mm-dd'),但是我还想统计这一天延迟单量啊,提前单量,该怎么写呢,求大神赐教