110,534
社区成员
发帖
与我相关
我的任务
分享
select a.name as 名称,DATEDIFF(MI,min(a.time),max(a.time)) as 时长,(SELECT CONVERT(varchar(100),b.time, 20) + '-》'
FROM TableName b
WHERE a.name = b.name FOR XML PATH('')) AS 时间段 from TableName a
group by a.name,a.state having a.state=1