如何在不使用聚合函数SUM（）的情况下添加列 [英] how to do addition of column without using aggregate function SUM()

问题描述

如何在不使用聚合函数的情况下添加列SUM（）

解决方案

  DECLARE   @ SUM   AS   INT    -   ？ 
  SET   @ SUM  =  0  
  SELECT   @ SUM  =  @ SUM  + COLUMN_TO_AGGREGATE  FROM  MY_TABLE 

这是最愚蠢的方法 - 构建聚合函数要快得多......

在sql中使用变量

将@Va声明为十进制。

设置@ Va = 0



和查询写如



选择@ Va = @ Va + Columnname from表

how to do addition of column without using aggregate function SUM()

解决方案

DECLARE @SUM AS INT --?
SET @SUM = 0
SELECT @SUM = @SUM + COLUMN_TO_AGGREGATE FROM MY_TABLE

And this is the most stupid way to do it - build in aggregate functions are much more faster...

using a variable in sql
Declare @Va as decimal.
set @Va=0

and query write like

select @Va=@Va+Columnname from Table

这篇关于如何在不使用聚合函数SUM（）的情况下添加列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！