STDEV的sql AVARAGE

Question

我想要一段时间的STDEV值的结果。我的密码出什么问题了？

select avg(X_MESURE) AS AVG_MESURE from (SELECT cast(DATE_PEREMPTION as date) as DATE_PEREMPTION, ROUND(STDEV(MESURE),3) AS X_MESURE FROM [MECMAS].[dbo].[T_Batch] B Join [MECMAS].[DBO].[TR_BATCH_MP] MP ON ([MP].ID_BATCH =B.ID ) Join [mecmas].[dbo].[T_DONNEES] d on (d.ID=MP.ID_DONNEES) WHERE B.DATE_PEREMPTION >= '2022-01-01 00:00:00.00' AND NAME='AGUA' group by cast(DATE_PEREMPTION as date)) ORDER BY X_MESURE

​

​

Answer 1

要么删除order子句，要么在括号内使用它，如下所示

select avg(X_MESURE) AS AVG_MESURE
from (SELECT cast(DATE_PEREMPTION as date) as DATE_PEREMPTION, ROUND(STDEV(MESURE),3) AS X_MESURE 
FROM [MECMAS].[dbo].[T_Batch] B 
Join [MECMAS].[DBO].[TR_BATCH_MP] MP 
ON ([MP].ID_BATCH =B.ID ) 
Join [mecmas].[dbo].[T_DONNEES] d 
on (d.ID=MP.ID_DONNEES) 
WHERE B.DATE_PEREMPTION >= '2022-01-01 00:00:00.00' AND NAME='AGUA' 
group by cast(DATE_PEREMPTION as date 
ORDER BY X_MESURE))