Oracle10gR2分析函数(中英对照版).pdf

Oraccle100gR2 分分析函函数  ((Translatting By caaizhuoyi)  说明明：  1、原文中底色为黄的部分翻翻译存在商榷榷之处，请大大家踊跃提意意见；  2、原文中淡蓝色色字体的文字字，不宜翻译译，保持原样样。  1Analytic Fuunctions  Anaalytic functionns compute an aggregaate value bassed on a grooup of rows. They differ from aggregate functtions in that they return multiple rowws for each ggroup. The ggroup of rowws is calleed a windoww and is deffined by the analytic__ clause. FFor each roww, a sliding winddow of rowss is defined. The windoww determiness the range of rows used to performm the calcculations for the current row. Windoww sizes can be based oon either a physical nummber of roows or a logical interval such as timme. 分析析函数通过将将行分组后，再再计算这些分分组的值。它它们与聚集函函数不同之处处在于能够对对每一 分组组返回多行值值。分析函数根根据analyttic_clauees将行分组，一个分组称称为一个窗口口。每 一行行都对应有一一个在行上滑滑动的窗口。该该窗口确定当当前行的计算算范围。窗口口大小可以用多个 物理理行进行度量量，也可以使使用逻辑区间进行度量，比如时间。 Anaalytic functions are the laast set of opperations perrformed in aa query exceept for the finnal ORDDER BY clausse. All joins and all WHERRE, GROUP BBY, and HAVVING clausees are complleted befoore the analyytic functions are processsed. Thereefore, analytiic functions can appear only in thhe select listt or ORDER BBY clause. 分析析函数是查询询中除需要在在最终处理的oorder by子子句之外最后后执行的操作作。所有连接接和所 有whhere，group by，和hhaving子句句都要在处理理分析函数之之前进行计算。因此，分析析函 数只只能用于select列或ordder by子句句中。 Anaalytic functions are commmonly used to compute cumulative, moving, ceentered, and repoorting aggregates. 分析析函数通常用用于计算数据据累积值，数据移动值、数数据中间值，，和输出集合合报表。 anaalytic_funnction::== anaalytic_funnction([ argumentss ]) OOVER (anaalytic_claause) anaalytic_claause::= [ qquery_parttition_cllause ] [ oorder_by_cclause [ windowingg_clause ] ] queery_partittion_clauuse::= PARRTITION BYY { value_exxpr[, valuue_expr ]... | ( value__expr[, vaalue_exprr ]... ) } ordder_by_claause::= ORDDER [ SIBLLINGS ] BBY { eexpr | possition | c_alias } [ AASC | DESCC ] [ NNULLS FIRSST | NULLLS LAST ] [,, { expr | pos