How can I avg(time(4)) in the following query:
select top 10 avg(e.Duration) from TimeTable e
I'm getting the following error:
Operand data type time is invalid for avg operator.
Duration is type time(4) such as:
Duration
-------------
00:00:10.0000
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…