SQL 语句实现分组 并计算

SELECT ID,DATEDIFF(n,MIN(TME),MAX(TIME)) AS ConTIME
FROM 表
WHERE STATE=1
GROUP BY ID