有没有办法获得其数据类型为varchar的列的Sum。 [英] Is there a way to get Sum of column whose datatype is varchar.

问题描述

在SQL中是否有办法获得数据类型为varchar的列的Sum。我在SQL中尝试使用Cast方法但它不起作用。如果有任何机构有想法，请与我分享。

查询我试过：
 
 选择强制转换（总和（总计）为  int ）来自 tbl_preorder 其中​​ emailid = '  [e-mail]' 

解决方案

反过来尝试：

  SELECT  SUM（CAST（总 AS   INT ）） FROM  tbl_preorder  WHERE  emailid = '  [e-mail]' 

试试这个。

 选择 sum（cast（总计） as   int ）来自 tbl_preorder  where  emailid = '  [e-mail]' 

 选择 SUM（CAST（总 AS   INT ））来自 tbl_preorder 其中 emailid = '  [e-mail]' 

Is there a way in SQL to get Sum of column whose datatype is varchar. I tried with Cast method in SQL but it doesn't work. If any body has an idea kindly share with me.

Query I tried: 

select cast(sum(Total) as int) from tbl_preorder where emailid='[e-mail]'

解决方案

Try the other way round:

SELECT SUM(CAST(Total AS INT)) FROM tbl_preorder WHERE emailid='[e-mail]'

Try this.

select sum(cast(Total) as int) from tbl_preorder where emailid='[e-mail]'

select SUM(CAST(Total AS INT))  from tbl_preorder where emailid='[e-mail]'

这篇关于有没有办法获得其数据类型为varchar的列的Sum。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！