经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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 7
14: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
72.232.63.* 于 2007-03-21 14:09:16发表:
Great work!
pai gow poker | keno online | monopoly slots | free online casino game | texas hold em online | strip blackjack game | roulette | free blackjack online | bonus casino online | computer poker
65.110.43.* 于 2007-03-20 13:35:03发表:
Nice site!
play poker | black jack game | poker | play texas holdem | free online bingo | free online slots no download | no download casino | free casino game | online baccarat | free three card poker
65.110.43.* 于 2007-03-20 13:34:23发表:
Nice site!
free slot machine downloads | play free roulette | free texas hold em | slot machine | online poker usa | casino download | free strip black jack | monopoly online | download free poker game | free monopoly online
65.110.43.* 于 2007-03-20 13:34:01发表:
Nice site!
free no deposit casino | poker stars | free online casino slots | omaha poker | play poker online | noble poker | casino games online | free slots | free poker websites | monopoly slot machine
65.110.43.* 于 2007-03-20 13:33:44发表:
Good design!
free roulette | download free poker games | free cleopatra slots | stud poker | no deposit bingo | poker stars download | free poker on line | casino free games | free joker poker | blackjack free games
65.110.43.* 于 2007-03-20 13:33:33发表:
Thank you!
sims free slots | poker game download | no deposit bonus casinos | slot games free | free blackjack game | play slots | free online casino games | gambling online | play blackjack | play poker for free
72.232.63.* 于 2007-03-19 13:12:02发表:
Well done!
free casino slot games | hold em poker | poker games free | free online casino slots | no deposit bonus | roulette online | free online texas holdem | play bingo online | play poker online | free casino slots
65.110.43.* 于 2007-03-19 13:11:36发表:
Great work!
slot machine games | monopoly slots | casino games free | online bingo | free video poker | free slots on line | free casino bonus | bonus casino online | free casino money | free online casino
72.232.63.* 于 2007-03-19 13:11:14发表:
Thank you!
casino free games | poker websites | flash casino | free no deposit casinos | free poker sites | play roulette | caribbean stud poker | play free online slots | free online poker game | play free slots online
72.232.63.* 于 2007-03-19 13:10:58发表:
Good design!
absolute poker | download free poker games | free monopoly online | no deposit casino | free slots | no download casino | slot machine software | no download slots | slot games | free joker poker
72.232.63.* 于 2007-03-19 13:10:46发表:
Thank you!
free blackjack game | free slot game | download poker game | online black jack | free texas holdem online | free slot machines | slot machine games free | download blackjack | online poker | online poker game
72.232.172.* 于 2007-03-19 01:51:04发表:
Nice site!
texas holdem | slot machine games | usa online casino | no deposit bingo | gambling online | games download | no deposit online casinos | casino on line | blackjack strip | poker stars download
72.232.172.* 于 2007-03-19 01:50:02发表:
Good design!
poker free download | slim slots | play slots for free | poker games download | black jack | texas hold em | free slot machines online | slot machines free | free poker download | internet bingo
72.232.172.* 于 2007-03-19 01:49:23发表:
Good design!
pacific poker | free slots no downloads | free slots game | play money poker | online casino bonus | 3 card poker | free poker games | poker machines | free slot | free gambling
72.232.172.* 于 2007-03-19 01:48:05发表:
Thank you!
play roulette free | blackjack online free | best online casinos | online slots | blackjack online | free cleopatra slots | slots online | free black jack game | free slot play | download free poker game
72.232.172.* 于 2007-03-19 01:46:44发表:
Thank you!
online baccarat | strip blackjack online | free games on line | full tilt poker | roulette free games | free slot game | online bingo games | casino deposit bonus | casino games online | free slots on line
65.110.43.* 于 2007-03-16 19:26:47发表:
Great work!
video slots | online poker games | free slots downloads | play black jack | flash casino | online slots | free casinos | gambling sites | caribbean poker | roulette free
65.110.43.* 于 2007-03-16 19:26:11发表:
Good design!
slot games free | poker game free | free video slots | free slots | play blackjack | strip blackjack | slot game | caribbean stud poker | roulette | free slot games
72.232.63.* 于 2007-03-16 19:25:36发表:
Great work!
download slots | strip blackjack online | casino online | free poker websites | poker game | free slot machines online | casino on line | download party poker | online bingo games | free on line poker
65.110.43.* 于 2007-03-16 19:25:21发表:
Nice site!
free slots games | online games | online slots free | poker stars | no deposit bonus casinos | free poker | free download poker | online casinos | download free poker game | play bingo online
65.110.43.* 于 2007-03-16 19:24:53发表:
Good design!
online texas hold em | monopoly slot machine | texas holdem | new online casinos | poker free | free cleopatra slots | roulette game | free games on line | internet gambling | free online poker games
65.110.43.* 于 2007-03-15 20:56:21发表:
Great work!
no deposit bonus | free slots downloads | roulette free games | games slots | free online poker | download poker game | free slot machine games | free online slot machine | free online casino games | free games online
65.110.43.* 于 2007-03-15 20:55:51发表:
Thank you!
play slot machines for free | poker free download | play poker | roulette games | free slots on line | online poker game | black jack | no download slots | free texas hold em | play bingo online
72.232.63.* 于 2007-03-15 20:55:18发表:
Nice site!
play slot machines | play texas hold em | casino games online | poker for free | free online slot machine games | texas holdem | free online slots no downloads | monopoly slot machine | online free blackjack | poker game download
65.110.43.* 于 2007-03-15 20:54:52发表:
Thank you!
free slots no download | empire poker | free slots for fun | free online slots no download | free poker games online | free poker | internet poker | russian roulette game | play casino games | live poker
65.110.43.* 于 2007-03-15 20:54:42发表:
Nice site!
aussie slots | pokerstars download | bingo online | strip blackjack | slots on line | free casinos | slot machines | play blackjack free | casinos on line | free internet poker
72.232.63.* 于 2007-03-14 21:52:38发表:
Great work!
casino poker | free monopoly online | casino online | slim slots free | online poker sites | blackjack strip | black jack game | poker bonus | paradise poker | online video slots
72.232.63.* 于 2007-03-14 21:51:53发表:
Well done!
on line gambling | virtual poker | free black jack games | computer poker | poker websites | free online slot machine | blackjack game | poker download | flash casinos | online texas holdem
72.232.63.* 于 2007-03-14 21:50:57发表:
Nice site!
free online casinos | free slots game | holdem poker | play free slots | video slot | free poker websites | free online strip blackjack | free poker download | online blackjack | free online texas hold em
72.232.63.* 于 2007-03-14 21:49:37发表:
Well done!
play slot machines | free internet poker | slot game | casino games | on line casinos | slot machines free | stud poker | free online poker | free texas holdem | play poker for free
72.232.63.* 于 2007-03-14 21:49:01发表:
Nice site!
roulette download | roulette games | free online bingo games | poker | no download slots | slim slots | play slots | online free blackjack | free casino games online | play free slot machines
65.110.43.* 于 2007-03-13 21:17:51发表:
Good design!
download free poker game | monopoly slots | play roulette | video slot machines | poker | casino free games | poker texas | online holdem | free 3 card poker | slot games
72.232.250.* 于 2007-03-13 21:17:38发表:
Well done!
free casino money | sims slots | online casino bonus | free play slot machines | free slots for fun | on line gambling | casino poker | blackjack online | free online bingo games | new online casinos
65.110.43.* 于 2007-03-13 21:17:31发表:
Good design!
black jack | online slots | texas holdem free | free money no deposit casinos | free slot downloads | free video | poker software | free slots | slot machine free | poker star
65.110.43.* 于 2007-03-13 21:17:21发表:
Well done!
free casino money | sims slots | online casino bonus | free play slot machines | free slots for fun | on line gambling | casino poker | blackjack online | free online bingo games | new online casinos
72.232.63.* 于 2007-03-13 21:16:21发表:
Well done!
free cleopatra slots | play texas hold em | free play slots | play texas holdem free | free poker games | online gambling sites | download free poker | casino games | strip blackjack | black jack download
72.232.63.* 于 2007-03-13 21:16:01发表:
Nice site!
play blackjack | flash casino | on line casinos | black jack games | free casino games online | play free slots | world series of poker | virtual poker | play roulette free | free video slot games
72.232.63.* 于 2007-03-13 04:06:58发表:
Well done!
casino bonus | full tilt poker | computer poker | casino games | free gambling games | poker bonus | star poker | free poker | free black jack | download poker games
65.110.43.* 于 2007-03-13 04:06:33发表:
Good design!
no deposit bingo | world series poker | online blackjack | online poker games | no deposit online casinos | free casino | online free blackjack | free games online | new no deposit casino | roulette free
65.110.43.* 于 2007-03-13 04:05:58发表:
Well done!
new casinos | free play slots | bingo online | online video slots | blackjack online | online bingo games | cleopatra slot | best online casinos | free on line slots | play free slots online