經(jīng)常發(fā)現(xiàn)一些網(wǎng)友問分析函數(shù)的問題，雖然分析函數(shù)比較多，有一些分析函數(shù)也確實比較難以理解，會給初學(xué)者有很大的心理壓力，其實對于大部分的分析函數(shù)，一般都不會有機會用到，所以把握常用的幾個分析函數(shù)就可以啦。 常用的分析函數(shù)如下所列: row_number() over(partition by ... order by ...) rank() over(partition by ... order by ...) dense_rank() over(partition by ... order by ...) count() over(partition by ... order by ...) max() over(partition by ... order by ...) min() over(partition by ... order by ...) sum() over(partition by ... order by ...) avg() over(partition by ... order by ...) first_value() over(partition by ... order by ...) last_value() over(partition by ... order by ...) lag() over(partition by ... order by ...) lead() over(partition by ... order by ...)示例： 14:33:29 SQL> select type,qty from test; TYPE QTY ---------- ---------- 1 3 1 6 2 5 2 9 2 714:33:36 SQL> select type,qty,to_char(row_number() over(partition by type order by qty))'/'to_char(count(*) over(partition by type)) as cnt2 from test; TYPE QTY CNT2 ---------- ---------- ------------ 1 3 1/2 1 6 2/2 2 5 1/3 2 7 2/3 2 9 3/3
