问题描述
我有一个名为 Employee 的表,上面有大约 17 个不同的列.其中一列称为年龄.我想写一个声明,该声明将获得声明中所有具有 AS 的员工的平均年龄.这是我写的声明,不幸的是我继续收到错误消息.另外,我是这方面的新手,所以请不要打我……哈哈.
I have a table called Employee with about 17 different columns on it. One of those columns is called age. I am suppose to write up a statement that will get the average age of all the employees with an AS in the statement. Here is the statement I have written up and unfortunately I continue to get an error message. Also, I am new at this so please don't beat me to hard...lol.
SELECT AVG(Age) AS Average_Age FROM Employee
我收到以下错误..
msg 8117,状态 16,第 1 行操作数平均值的无效语法.
我相信消息告诉我平均值正在尝试计算,但无法执行.
I believe the message is telling me that the avg is trying to calculate, but cannot do it.
为什么我在 youtube 视频上看到了这个,而且它对创建它的人来说效果很好?虽然我做了完全相同的陈述,但我错了……有人可以解释一下吗?
Why did I see this done on a youtube video and it work perfectly for the person who created it? While I did the same exact statement I got it wrong...can someone explain that?
根据评论更新:
错误信息:
操作数数据类型 varchar 对于 avg 运算符无效.
推荐答案
如果 age 是 varchar 列你可以试试
If age is a varchar column you can try
SELECT AVG(cast(Age as int)) AS Average_Age FROM Employee
(但您可能需要考虑更改数据类型)
( but you may want to think about changing the datatype )
这篇关于选择,平均语句不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!