经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.93.* 于 2006-12-30 01:11:51发表:
Good design!
poker for us players | free online bingo games | texas hold em | poker us | russian roulette game | casino poker | free poker games online | slot game | poker casino | flash casino
72.232.93.* 于 2006-12-29 06:35:16发表:
Good design!
poker site usa | free gambling | free online slot machine games | free roulette | best online casinos | casino game | draw poker | play free slots online | free online poker games | free slot machines games
72.232.93.* 于 2006-12-29 06:34:50发表:
Nice site!
sim slots | on line casino | play money poker | online poker software | free slots download | video poker download | slim slots | gambling poker machine | black jack free | play free blackjack
72.232.93.* 于 2006-12-29 06:34:45发表:
Nice site!
live poker | poker casino | free poker online | free blackjack | texas poker | poker tour | gambling poker | 3 card poker | machine games | play slot machines for free
72.232.93.* 于 2006-12-29 06:34:14发表:
Great work!
online gaming | free slots no download | casino game download | no deposit casino | 10 best online casinos | free money no deposit casinos | poker review star | video slots | poker open to us | poker online
72.232.93.* 于 2006-12-29 06:34:00发表:
Nice site!
live poker | poker casino | free poker online | free blackjack | texas poker | poker tour | gambling poker | 3 card poker | machine games | play slot machines for free
72.232.93.* 于 2006-12-28 09:36:55发表:
Thank you!
black jack | free slot machines | internet casino poker | keno games | poker games online | play texas holdem | poker casino | noble poker | free online slots no download | free blackjack game
72.232.93.* 于 2006-12-28 09:36:15发表:
Thank you!
black jack | free slot machines | internet casino poker | keno games | poker games online | play texas holdem | poker casino | noble poker | free online slots no download | free blackjack game
72.232.93.* 于 2006-12-28 09:35:34发表:
Good design!
free gambling | best casinos | no deposit bonus | free money no deposit casinos | video slot games | online texas hold em | online gaming | free video poker | online texas holdem | slot game
72.232.93.* 于 2006-12-28 09:35:26发表:
Thank you!
casino games | no download slots | best poker sites | online poker rooms | video slots | texas poker | world series poker | casino slot machine | play free cleopatra slots online | play bingo online
65.110.43.* 于 2006-12-27 00:08:49发表:
Well done!
online poker rooms | blackjack online | poker for fun | online poker accept us | play bingo | play casino game | keno online | full tilt poker | slot online | play casino games
65.110.43.* 于 2006-12-27 00:08:34发表:
Nice site!
free bingo games | free internet poker | machine games | best casino bonus | game poker | free bonus slots | russian roulette game | play poker usa | roulette free | free money casinos
72.232.93.* 于 2006-12-27 00:08:01发表:
Great work!
play poker on line | black jack free | poker games free | casino on line | blackjack free games | casino game online | poker stars download | poker room | free play slots | poker cards
65.110.43.* 于 2006-12-27 00:08:00发表:
Good design!
multi hand poker | world series of poker download | free poker downloads | card poker | stud poker | gambling sites | slot machine | black jack game | play free blackjack online | casino no deposit
65.110.43.* 于 2006-12-27 00:07:40发表:
Nice site!
new no deposit casinos | free video slots | blackjack free | free online roulette | real poker | online gaming casinos | online holdem | roulette odds | internet poker room | best online casinos
72.232.93.* 于 2006-12-26 03:52:34发表:
Nice site!
free slots for fun | no deposit bonus casinos | machine games | poker game free | internet gambling | free slot machine | online poker room | play online poker | casino games | poker us welcome
72.232.93.* 于 2006-12-26 03:52:25发表:
Good design!
poker stars download | play black jack | caribbean stud poker | no limit holdem | poker us | play poker | virtual poker | download free poker games | free online casinos | play free cleopatra slots online
65.110.43.* 于 2006-12-26 03:52:23发表:
Well done!
free poker on line | gambling casinos | free no deposit casinos | online gambling casino | play blackjack online | casino game online | slot game | online gambling | casino portal | internet bingo
65.110.43.* 于 2006-12-26 03:52:16发表:
Thank you!
party poker download | new no deposit casinos | no deposit bingo online | poker accept usa | new no deposit online casinos | play slot machines | keno games | roulette free | online texas holdem | internet gambling sites
72.232.93.* 于 2006-12-26 03:52:02发表:
Good design!
casino online | roulette game | online holdem | poker texas hold em | online paigow poker | online casino poker | pacific poker | play free slot machine game | download poker | crazy game of poker
65.110.43.* 于 2006-12-24 15:09:31发表:
Good design!
machine games | online hold em | internet casino gambling online | monopoly slot machine | play roulette online | texas holdem | free casino downloads | poker gambling | draw poker | play free blackjack online
72.232.93.* 于 2006-12-24 15:07:55发表:
Good design!
casino games free | poker us welcome | world series of poker download | casino game | casino royale | poker room review | free online video slots | noble poker | download free poker games | full tilt poker
65.110.43.* 于 2006-12-24 15:06:50发表:
Great work!
free slot machine games online | online poker review room | absolute poker | casino online | free poker game | free texas holdem poker | internet blackjack | free poker tournaments | new no deposit online casinos | online poker usa
65.110.43.* 于 2006-12-24 15:05:56发表:
Well done!
free slot machine downloads | internet poker room | free no deposit casinos | poker game online | download poker | slots free | poker site usa | hold em poker | free poker online | online poker room
65.110.43.* 于 2006-12-24 15:05:39发表:
Nice site!
no limit texas holdem | poker accept us | easy online real bingo | caribbean poker | keno games | free online texas holdem | slot games free | poker software | gambling games | roulette download
72.232.93.* 于 2006-12-23 17:41:55发表:
Well done!
flash casinos | world poker tour | online slots | free play slots | free three card poker | online gambling bonuses | blackjack download | black jack online | empire poker | free money casino
72.232.93.* 于 2006-12-23 17:40:27发表:
Well done!
free cash casinos | gambling poker | blackjack game | casino free games | free slots on line | online roulette | slots online | sim slots | play online poker | card poker
72.232.93.* 于 2006-12-23 17:39:24发表:
Great work!
poker money | texas poker | planet poker | poker online free | download party poker | download free poker | party poker download | keno online | roulette free games | casinos online
65.110.43.* 于 2006-12-23 17:38:37发表:
Nice site!
free bingo cards | bingo online | free slot machine games online | slots for fun | free slot machine downloads | paradise poker | casino poker | online poker game | blackjack free games | bonus poker
72.232.93.* 于 2006-12-23 17:38:11发表:
Nice site!
play blackjack | free slot machines | earn cash playing poker | live poker | casino no deposit | multi hand poker | play casino game | blackjack online free | free fun slots | free on line slot machines
72.232.93.* 于 2006-12-22 19:27:31发表:
Great work!
poker rooms accepting usa | free motorola keypress ringtones | online gambling holdem | no deposit casino | free mp3 ringtones | casino game | cingular phone free ringtones | i730 mp3 nextel ringtone | free black jack | poker for free
65.110.43.* 于 2006-12-22 19:26:07发表:
Well done!
boost mobile ringtones | free on line poker | internet casino poker | black jack online | free sanyo sprint ringtones | 10 best online casinos | free slot games | play online poker | casino portal | online roulette
65.110.43.* 于 2006-12-22 19:25:28发表:
Great work!
free no deposit casinos | free cellular one ringtones | download party poker | free online strip blackjack | omaha poker | free online casinos | multiplayer poker | free bollywood ringtones | online hold em | best internet poker
65.110.43.* 于 2006-12-22 19:24:56发表:
Good design!
motorola ringtones free | free gambling games | ringtone jukebox ringtone jukebox | free verizon ringtones | sprint sanyo free ringtones | christian music ringtones | ringtones for tracfone carriers | free slot play | 24 ctu ringtone verizon | play slot machines for free
65.110.43.* 于 2006-12-22 19:24:38发表:
Nice site!
absolute poker | free video poker | mtv ringtones | roulette free games | play blackjack online | cingular cell phone ringtones | gospel ringtones | free video slots | free slots online | poker site
72.232.93.* 于 2006-12-22 00:16:04发表:
Well done!
slot machine software | free monopoly slots | free slot downloads | black jack free | poker review star | gamble poker | texas holdem poker | poker online free | online gambling holdem | no deposit bonus
65.110.43.* 于 2006-12-22 00:14:34发表:
Great work!
casino online games | free casinos | poker game free | online bingo games | poker accept usa | internet casino poker | free poker on line | slots games | free texas holdem | free on line slots
65.110.43.* 于 2006-12-22 00:13:00发表:
Good design!
flash casino games | roulette online | poker card game | best internet casinos | free poker tournaments | russian roulette game | money poker | casino game online | absolute poker | casinos on line
72.232.92.* 于 2006-12-22 00:11:56发表:
Good design!
free bingo games | free slot play | video poker free | play roulette online | holdem poker online | internet casino | holdem poker texas | no limit texas hold em | online holdem | free cash casinos
65.110.43.* 于 2006-12-22 00:11:23发表:
Well done!
casino bonus | poker games online | world series of poker | cleopatra slots | internet casino gambling online | online poker rooms | online slots free | keno games | party poker download | poker us welcome