34,838
社区成员




select userid,case when datediff(mi,min(createtime),max(createtime))>60 then '否' else '是' end
from
(
select top 2 * from #t as aa
where userid = 'A' order by createtime desc
)tbl
group by userid
create table #t
(
id int identity(1,1),
userid nvarchar(60),
createtime datetime
)
insert #t select 'A',getdate()
insert #t select 'A',getdate()
go
select userid,case when datediff(mi,min(createtime),max(createtime))>60 then '是' else '否' end
from
(
select top 2 * from #t as aa
where userid = 'A' order by createtime desc
)tbl
group by userid
select m.* , n.* from
(select * , px = (select count(1) from [user] where userid = t.userid and createtime > t.createtime) + 1 from [user] t) m,
(select * , px = (select count(1) from [user] where userid = t.userid and createtime > t.createtime) + 1 from [user] t) n
where m.userid = n.userid and m.px = 1 and n.px = 2 and datediff(hh, n.createtime , m.createtime) = 1