56,681
社区成员
发帖
与我相关
我的任务
分享
select name
from a t1
where STATUS=0
and not exist (select 1 from a where name=t1.name and time<t1.time)
select time,count(*)
from a t1
where STATUS=0
and not exists (select 1 from a where name=t1.name and time<t1.time)
group by time
select time,count(*)
from a t1
where STATUS=0
and not exist (select 1 from a where name=t1.name and time<t1.time)
group by time
select a.time,count(*) from a where a.status = 0 group by (a.TIME/(24*3600))*24*3600)