摘要: (1)分析函数(Analytic function)与聚合函数(Aggregate function); (2)基本语法; (3)AVG, SUM, MAX, MIN, COUNT; (4)RANK, DENSE_RANK, ROW_NUMBER; (5)LEAD, LAG; (6)FIRST_VALUE, LAST_VALUE; (7)Window子句 阅读全文
posted @ 2010-09-08 13:19 Morven.Huang 阅读(2811) 评论(2) 推荐(2) 编辑