blocks|key|1543611|text|不能，但您可以使用数学:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1543612|如果yourColumn总是大于零：|offset|length|style|CODE|1543613|select+EXP(SUM(LOG(yourColumn)))+As+ColumnProduct+from+yourTable|code-block|syntax|javascript|1543614|entityMap^0|0|2|A|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

No, but you can use Mathematics :)

if <code>yourColumn</code> is always bigger than zero:

<pre><code>select EXP(SUM(LOG(yourColumn))) As ColumnProduct from yourTable
</code></pre>

blocks|key|5213042|text|我发现Oracle的答案仍然缺失，所以它是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5213043|SQL>+with+yourTable+as
++2++(+select+1+yourColumn+from+dual+union+all
++3++++select+2+from+dual+union+all
++4++++select+4+from+dual+union+all
++5++++select+8+from+dual
++6++)
++7++select+EXP(SUM(LN(yourColumn)))+As+ColumnProduct+from+yourTable
++8++/

COLUMNPRODUCT
-------------
+++++++++++64

1+row+selected.|code-block|syntax|javascript|5213044|致以敬意，|5213045|罗伯。|5213046|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I see an Oracle answer is still missing, so here it is:

<pre><code>SQL&gt; with yourTable as
 2 ( select 1 yourColumn from dual union all
 3 select 2 from dual union all
 4 select 4 from dual union all
 5 select 8 from dual
 6 )
 7 select EXP(SUM(LN(yourColumn))) As ColumnProduct from yourTable
 8 /

COLUMNPRODUCT
-------------
 64

1 row selected.
</code></pre>

Regards, 
Rob.

blocks|key|3610593|text|使用PostgreSQL，您可以创建自己的聚合函数，请参见http://www.postgresql.org/docs/8.2/interactive/sql-createaggregate.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3610594|要在MySQL上创建聚合函数，需要构建一个.so+(linux)或.dll+(windows)文件。这里显示了一个示例：http://www.codeproject.com/KB/database/mygroupconcat.aspx|3610595|我对mssql和oracle不太确定，但我打赌他们也有创建自定义聚合的选项。|3610596|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/8.2/interactive/sql-createaggregate.html|1|http://www.codeproject.com/KB/database/mygroupconcat.aspx^0|T|1Z|0|0|1O|1L|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

With PostgreSQL, you can create your own aggregate functions, see <a href="http://www.postgresql.org/docs/8.2/interactive/sql-createaggregate.html" rel="nofollow">http://www.postgresql.org/docs/8.2/interactive/sql-createaggregate.html</a>

To create an aggregate function on MySQL, you'll need to build an .so (linux) or .dll (windows) file. An example is shown here: <a href="http://www.codeproject.com/KB/database/mygroupconcat.aspx" rel="nofollow">http://www.codeproject.com/KB/database/mygroupconcat.aspx</a>

I'm not sure about mssql and oracle, but i bet they have options to create custom aggregates as well.

blocks|key|2126015|text|随着数字的增加，您将相当快地分解任何数据类型。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2126016|使用LOG/EXP是棘手的，因为数字<=+0在使用LOG时会失败。我用this+question写了一个解决方案来处理这个问题|offset|length|style|BOLD|2126017|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/3653586/sql-server-query-to-bring-groupwise-multiplication/3653623#3653623^0|0|A|3|Z|D|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]]|9|@$D|T|E|U|1|V]]|A|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

You'll break any datatype fairly quickly as numbers mount up.

Using LOG/EXP is tricky because of numbers &lt;= 0 that will fail when using LOG. I wrote a solution in <a href="https://stackoverflow.com/questions/3653586/sql-server-query-to-bring-groupwise-multiplication/3653623#3653623">this question</a> that deals with this

blocks|key|2123108|text|在MS+SQL中使用CTE：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2123109|CREATE+TABLE+Foo(Id+int,+Val+int)
INSERT+INTO+Foo+VALUES(1,+2),+(2,+3),+(3,+4),+(4,+5),+(5,+6)

;WITH+cte+AS+
(
++++SELECT+Id,+Val+AS+Multiply,+row_number()+over+(order+by+Id)+as+rn
++++FROM+Foo
++++WHERE+Id=1
++++UNION+ALL
++++SELECT+ff.Id,+cte.multiply*ff.Val+as+multiply,+ff.rn+FROM
++++(SELECT+f.Id,+f.Val,+(row_number()+over+(order+by+f.Id))+as+rn
++++FROM+Foo+f)+ff
++++++++INNER+JOIN+cte
++++++++ON+ff.rn+-1=+cte.rn
)
SELECT+*+FROM+cte|code-block|syntax|javascript|2123110|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Using CTE in MS SQL: 

<pre><code>CREATE TABLE Foo(Id int, Val int)
INSERT INTO Foo VALUES(1, 2), (2, 3), (3, 4), (4, 5), (5, 6)

;WITH cte AS 
(
 SELECT Id, Val AS Multiply, row_number() over (order by Id) as rn
 FROM Foo
 WHERE Id=1
 UNION ALL
 SELECT ff.Id, cte.multiply*ff.Val as multiply, ff.rn FROM
 (SELECT f.Id, f.Val, (row_number() over (order by f.Id)) as rn
 FROM Foo f) ff
 INNER JOIN cte
 ON ff.rn -1= cte.rn
)
SELECT * FROM cte
</code></pre>

blocks|key|5212923|text|不确定是Oracle还是sql-server，但在MySQL中，您可以像往常一样使用*。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5212924|mysql>+select+count(id),+count(id)*10+from+tablename;
%2B-----------%2B--------------%2B
%7C+count(id)+%7C+count(id)*10+%7C
%2B-----------%2B--------------%2B
%7C+++++++961+%7C+++++++++9610+%7C
%2B-----------%2B--------------%2B
1+row+in+set+(0.00+sec)|code-block|syntax|javascript|5212925|entityMap^0|16|1|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Not sure about Oracle or sql-server, but in MySQL you can just use <code>*</code> like you normally would.

<pre><code>mysql&gt; select count(id), count(id)*10 from tablename;
+-----------+--------------+
| count(id) | count(id)*10 |
+-----------+--------------+
| 961 | 9610 |
+-----------+--------------+
1 row in set (0.00 sec)
</code></pre>

In SQL there are aggregation operators, like AVG, SUM, COUNT. Why doesn't it have an operator for multiplication? "MUL" or something.

I was wondering, does it exist for Oracle, MSSQL, MySQL ? If not is there a workaround that would give this behaviour?

Multiplication aggregate operator in SQL

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在SQL中有聚合运算符，如AVG、SUM、COUNT。为什么它没有乘法运算符？"MUL“之类的我想知道，它是否存在于Oracle，MSSQL，MySQL？如果不是，是否有解决方法可以解决此问题？

问SQL中的乘法聚合运算符
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中的乘法聚合运算符EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL中的乘法聚合运算符
EN