经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
65.110.43.* 于 2007-01-22 11:51:02发表:
Well done!
online holdem | poker rooms accepting usa | casinos on line | poker review | texas holdem free | blackjack online free | black jack games | free online poker games | monopoly slot machine | blackjack software
65.110.43.* 于 2007-01-22 11:50:33发表:
Thank you!
free slot machine play | free slot machine games | on line poker | sim slots | video slot games | free poker software | casino on net | poker games online | online casino | no limit texas hold em
65.110.43.* 于 2007-01-22 11:50:17发表:
Nice site!
poker usa open | poker stars download | play free video slots | free online casino games | play poker on line | free online slot machines | caribbean stud poker | online gambling holdem | free money no deposit casinos | free blackjack game
65.110.43.* 于 2007-01-21 11:26:43发表:
Nice site!
empire poker | world series poker | casino slot machine | video slot games | blackjack online | party poker | free cash casinos | free online texas holdem | online casino bonus | world series of poker
65.110.43.* 于 2007-01-21 11:26:06发表:
Well done!
cleopatra slot machine | games slots | online poker game | poker games | poker room review | multi hand poker | play free blackjack online | online poker sites | play roulette online | play poker for free
65.110.43.* 于 2007-01-21 11:25:51发表:
Thank you!
free slot machine play | free online poker games | play free cleopatra slots online | online poker rooms | poker games free | poker sites | slots on line | black jack game | free blackjack online | holdem poker online
65.110.43.* 于 2007-01-21 11:24:39发表:
Thank you!
free slot machine games online | free poker downloads | free online slots no download | stud poker | poker gambling | online gambling bonuses | roulette odds | real money poker | black jack online | poker pages
65.110.43.* 于 2007-01-21 11:24:16发表:
Well done!
machine games | free online slots games | full poker review tilt | playing poker | poker site us | black jack download | best online casinos | monopoly slots | play blackjack | monopoly online
72.232.250.* 于 2007-01-20 12:24:39发表:
Good design!
free slot downloads | uk poker | free money no deposit casinos | online casino blackjack | poker game free | world series poker | online poker rooms | blackjack free | free online casinos | online texas holdem
65.110.43.* 于 2007-01-20 12:24:06发表:
Great work!
poker accepting americans | download free poker | casino poker | poker review star | poker room rating | casino slots | slots online | online texas hold em | caribbean poker | sims slots
65.110.43.* 于 2007-01-20 12:23:26发表:
Great work!
play slot machines | russian roulette game | free no deposit casinos | online roulette | online gambling holdem | online gambling games | free slot games online | poker for us players | free online bingo games | free blackjack online
72.232.250.* 于 2007-01-20 12:22:30发表:
Good design!
bingo cards | play slot machines for free | gamble poker | play free slot machine game | play poker on line | poker gambling | slots on line | free poker games online | flash casino | roulette free games
65.110.43.* 于 2007-01-20 12:21:53发表:
Well done!
play free blackjack | slot machine game | earn cash playing poker | bonus poker | online poker review room | texas holdem poker | free on line games | internet casino | aussie slots | play poker for free
65.110.43.* 于 2007-01-19 11:54:05发表:
Thank you!
poker money | free slot machine games | pai gow poker | free online texas holdem | poker sites accept us | poker pages | casino online | live poker rooms | aussie slots | casino games free
72.232.250.* 于 2007-01-19 11:53:01发表:
Nice site!
online roulette | slot machine | free slots casino | internet gambling sites | free slots games | new no deposit casinos | video slot machines | cleopatra slots | poker machines | caribbean stud poker
65.110.43.* 于 2007-01-19 11:51:57发表:
Nice site!
poker directory | black jack | black jack games | play internet poker online | bingo online | gambling poker | video poker free | free no deposit casinos | free blackjack online | poker site usa
72.232.93.* 于 2007-01-19 11:51:47发表:
Good design!
poker texas hold em | online poker sites | poker game | caribbean poker online | gambling game | poker rooms | blackjack online | play texas holdem | play casino games | no deposit bingo online
65.110.43.* 于 2007-01-19 11:51:32发表:
Good design!
poker texas hold em | online poker sites | poker game | caribbean poker online | gambling game | poker rooms | blackjack online | play texas holdem | play casino games | no deposit bingo online
72.232.250.* 于 2007-01-19 11:50:50发表:
Well done!
texas holdem poker online | game poker | pacific poker | play free slot machines | poker accept usa | free blackjack game | poker tables | poker accept us | best casino bonus | internet poker
72.232.250.* 于 2007-01-18 11:22:23发表:
Nice site!
casino stud poker | slots on line | play roulette online | no download casino | on line poker | free slot machine games | free poker games | play blackjack online | free blackjack online | blackjack odds
65.110.43.* 于 2007-01-18 11:21:28发表:
Great work!
free poker tournaments | poker rooms accepting usa | free bingo games | play online poker | caribbean poker online | free slot machine play | online poker us | poker free | earn cash playing poker | no limit texas hold em
65.110.43.* 于 2007-01-18 11:20:39发表:
Well done!
omaha poker | bingo cards | empire poker | texas holdem | poker accept usa | internet casinos | gambling online | video slot machines | play poker online | poker tour
72.232.93.* 于 2007-01-18 11:19:55发表:
Well done!
full tilt poker | online poker software | machine games | on line gambling | world poker tour | online poker game | gambling game | keno | online video poker | bonus poker
72.232.92.* 于 2007-01-17 11:51:24发表:
Thank you!
full poker review tilt | no deposit bonus | best internet poker | poker room rating | online slots | play casino games | video poker | play texas holdem | live poker rooms | real poker
65.110.43.* 于 2007-01-17 11:51:22发表:
Thank you!
casino on line | poker stars download | slot machine software | play black jack | online gambling games | poker us welcome | free bingo cards | free slot machine play | poker machines | free gambling
65.110.43.* 于 2007-01-17 11:51:17发表:
Well done!
poker usa open | free poker on line | casino games | online paigow poker | virtual poker | casino royale | paradise poker | free money casino | on line casinos | slot machine
65.110.43.* 于 2007-01-17 11:49:25发表:
Nice site!
gambling game | free slot machines | play blackjack online | free slots for fun | free casino online | online poker rooms | online casino | free poker tournaments | online casinos | texas holdem
72.232.250.* 于 2007-01-17 11:48:24发表:
Good design!
poker online | poker downloads | poker review star | poker for free | computer poker games | poker hold em | uk poker | free casino slots | poker for fun | free 3 card poker
65.110.43.* 于 2007-01-17 11:48:09发表:
Thank you!
casino on line | poker stars download | slot machine software | play black jack | online gambling games | poker us welcome | free bingo cards | free slot machine play | poker machines | free gambling
72.232.250.* 于 2007-01-16 09:14:51发表:
Good design!
free casino slot games | online texas hold em | online paigow poker | poker tour | free cash casinos | free poker software | play free slots | free money casino | free slot machines games | poker accept usa
65.110.43.* 于 2007-01-16 09:14:07发表:
Well done!
poker tournament | full poker review tilt | free casinos | casino on net | blackjack free | play internet poker online | free slots no download | full tilt poker | casino no deposit | free fun slots
72.232.250.* 于 2007-01-16 09:13:40发表:
Good design!
poker downloads | internet casino | poker accept us | free online poker games | slot online | free slot machine play | poker online free | slot machine software | gamble poker | free casino slots
72.232.250.* 于 2007-01-16 09:13:40发表:
Good design!
poker downloads | internet casino | poker accept us | free online poker games | slot online | free slot machine play | poker online free | slot machine software | gamble poker | free casino slots
65.110.43.* 于 2007-01-16 09:12:11发表:
Good design!
black jack online | casino slot machine | free 3 card poker | poker game online | slot game | play bingo online | free poker tournaments | free money no deposit casinos | casinos with no deposit | free joker poker
72.232.93.* 于 2007-01-16 09:11:18发表:
Great work!
roulette odds | gambling on line | poker websites | poker money | no deposit bonus casinos | black jack games | online slots free | on line gambling | no deposit bingo online | free blackjack game
72.232.250.* 于 2007-01-15 09:23:48发表:
Nice site!
casino online | no deposit bingo online | download free poker | blackjack online | free poker sites | free online texas hold em | free slot play | play poker game | monopoly slots | poker online
72.232.93.* 于 2007-01-15 09:23:25发表:
Great work!
casino game | internet gambling | free online gambling | no deposit bonus casinos | pacific poker | russian roulette game | online video poker | draw poker | free no deposit casinos | play free slot machine games
72.232.250.* 于 2007-01-15 09:23:12发表:
Thank you!
free money no deposit casinos | online poker software | poker directory | free money casinos | casino game download | video slot machines | online free poker | playing roulette | party poker | slots for fun
72.232.250.* 于 2007-01-15 09:22:05发表:
Good design!
free slot games online | free online slots no download | free slim slots | poker hold em | free roulette online | play poker online | online gaming | online poker tournament | casino stud poker | flash casinos
72.232.93.* 于 2007-01-15 09:21:53发表:
Well done!
new no deposit casinos | online casino | poker casino | free online slot machine games | online casino bonus | online bingo games | free online strip blackjack | poker rooms | poker sites accept us | play online poker