34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT left(device_data,8) AS [date],AVG(device_value)
FROM table1
GROUP BY left(device_data,8)
在原来列表后增加一列:
SELECT *,AVG(device_value)OVER(PARTITION BY left(device_data,8))
FROM table1
select LEFT(T.device_data,LEN(T.device_data)-6) from T