Oracle分析函数——函数列表 SUM :该函数计算组中表达式的累积和 MIN :在一个组中的数据窗口中查找表达式的最小值 MAX :在一个组中的数据窗口中查找表达式的最大值 AVG :用于计算一个组和数据窗口内表达式的平均值。 COUNT :对一组内发生的事情进行累积计数 ----------------------------------------------------------------------------------- -------------- RANK :根据ORD
Ranking family - This family supports business questions like “show the top 10 and bottom 10 salesperson per each region” or “show, for each region, salespersons that make up 25% of the sales”. The functions examine the entire output before producin
Oracle Built-in Functions Version 10.2 Function Name Analytic Collection Conver sion Date Time Data Mining Misc. Model Clause Null Handling Numeric Object String XML ABS ACOS ADD_MONTHS ADJ_DATE APPENDCHILDXML ASCII ASCIISTR ASIN ATAN ATAN2 AVG BFIL
比如获取每个表的前10%个字段。 代码如下: select id , name , colid , rn from ( select * , rn = ntile (10 ) over (partition by id order by colorder ) from syscolumns )t where rn = 1