mysql有相当于Oracle的“分析函数”吗？ [英] Does mysql have the equivalent of Oracle's "analytic functions"?

问题描述

http://docs.oracle.com/ cd / B19306_01 / server.102 / b14200 / functions001.htm＃sthref964

分析函数根据组
行。它们与聚合函数不同，它们为每个组返回
多行。

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group.

推荐答案

p> NO，它是MySQL的主要缺点之一，相比其他DBMS如MSSQL，Oracle，PostgreSQL。我强烈怀疑在任何未来的MySQL中看到Window函数，特别是在Oracle收购MySQL之后...

NO, it is one of the main lack of MySQL, compared to others DBMS like MSSQL, Oracle, PostgreSQL. I strongly doubt to see Window Functions in MySQL in any future, especially after Oracle acquisition of MySQL ...

这篇关于mysql有相当于Oracle的“分析函数”吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！