SQL语句如何查询各个用户最长的连续登陆天数?
ref: https://bbs.csdn.net/topics/392243867 if not object_id(N'Tempdb..#Tmp_Data') is null drop table #Tmp_Data Go create table #Tmp_Data ( List_ID int identity(1,1), UID varchar(10), LoadTime datetime ) INSERT INTO #Tmp_Data Select '201','2017/01/01' union all Select '201','2017/01/02' union all Select '202','2017/01/...阅读全文