分析报表类SL语句.ppt

利用SQL扩展进行报表和分析;Row Source;Result Set;嵌套查询(inline Query);嵌套查询(inline Query);With语句;With语句;Top-N 查询;Top-N 查询(8i above);Top-N查询(8i below);Top-N查询(8i above);Top-N查询(8i below);Top-N查询(8i above);Top-N查询(8i below);层次化查询(Connect By);层次化查询;Decode函数;简单的decode语句;灵活报表(Cross-Tab Report);灵活报表(Cross-Tab Report);动态查询(Dynamic Select);动态更新(Dynamic Update);Case语句;简单的case语句;Case语句(不等比较);嵌套Case语句;查询列（Column Select);查询列基本结构;查询列作为表达式;SQL for Aggregation ;ROLLUP Extension to GROUP BY;Rollup语法;Rollup例子;Partial Rollup;Partial Rollup例子;CUBE Extension to GROUP BY;Cube扩展例子;Partial CUBE;Partial CUBE例子;GROUPING Functions;Grouping语法;Grouping函数例子;Decode和Grouping函数结合;Decode和Grouping函数结合例子;Grouping函数用于结果集合过滤;Grouping用于过滤集合;Grouping用于过滤集合;GROUPING_ID Function;Grouping_id函数例子;GROUPING SETS Expression;Grouping sets字句例子;Group_id函数;Group_id例子;Composite Columns;比较说明;Composite Columns例子;Concatenated Groupings;Concatenated Groupings例子;Concatenated Groupings例子;Concatenated Groupings and Hierarchical Data Cubes;SQL for Analysis and Reporting ;分析类函数的处理位置;分析类函数的主要能力;Ranking Functions;Rank Function;DENSE_RANK Functions;Rank和dense_rank的区别;Ranking Order;NULLS FIRST | NULLS LAST ;Ranking on Multiple Expressions;Per Group Ranking;Per Cube and Rollup Group Ranking;Treatment of NULLs;Bottom N Ranking;CUME_DIST Function;Cume_dist例子;PERCENT_RANK Function;Percent_rank函数例子;NTILE Function;Ntile函数例子;ROW_NUMBER Function;Row_number函数例子;Windowing Aggregate Functions;窗口函数基本语法;Treatment of NULLs as Input to Window Functions;Windowing Functions with Logical Offset;累积窗口函数示例;移动窗口函数示例 ;Centered Aggregate Function;Windowing Aggregate Functions in the Presence of Duplicates;Varying Window Size for Each Row;Windowing Aggregate Functions with Physical Offsets;First_value/Last_value;FIRST_VALUE and LAST_VALUE Functions;IGNORE NULLS ;Reporting Aggregate Functions;报表统计类函数例子;报表统计类函数例子;RATIO_TO_REPORT Function;RATIO_TO_REPORT例子;LAG/LEAD Functions;Lag和lead函数例子;FIRST/LAST Functions;FIRST/LAST As Regular Aggregates;FIRST/LAST As Reporting Aggre