经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.250.* 于 2007-01-07 08:33:08发表:
Thank you!
on line gambling | free online slots no download | caribbean poker | free roulette online | play free slots online | no deposit bonus casinos | free blackjack game | money poker | free slot | real money poker
65.110.43.* 于 2007-01-07 08:32:35发表:
Great work!
online casino bonus | stud poker | bingo online | download free poker | poker stars download | joker poker | omaha poker | slots for free | free casino money | gambling games
72.232.250.* 于 2007-01-06 08:54:13发表:
Nice site!
online gambling bonuses | poker site usa | poker tournament | poker accepting americans | online holdem | poker sites | free texas holdem poker | casino online games | free black jack | poker usa
65.110.43.* 于 2007-01-06 08:53:19发表:
Well done!
roulette game | free online strip blackjack | free video poker | keno games | online gambling holdem | free on line poker | play online poker | bingo cards | caribbean stud poker | play blackjack free
65.110.43.* 于 2007-01-06 08:52:05发表:
Nice site!
gambling poker machine | online poker software | texas hold em poker online | internet poker game | online roulette | poker free | play free cleopatra slots online | online casino slots | roulette online | blackjack online
72.232.92.* 于 2007-01-06 08:51:27发表:
Thank you!
casinos online | online black jack | no limit hold em | internet casino | casino download | play slots | free casinos | free slot games | poker review | free texas holdem
72.232.250.* 于 2007-01-06 08:50:49发表:
Great work!
free online video slots | flash casino | free online slot games | multiplayer poker | poker sets | free on line slot machines | empire poker | monopoly slots | casino game download | slots on line
72.232.250.* 于 2007-01-05 07:30:05发表:
Well done!
play free slots online | internet poker game | internet casino | free slot games | roulette free | free online casino games | casino portal | poker party | download poker | poker online free
72.232.93.* 于 2007-01-05 07:29:19发表:
Great work!
free blackjack game | online texas holdem | world series of poker download | online casino games | new no deposit casinos | card poker | no deposit casinos | internet casino gambling | monopoly slot machine | free slots online
72.232.93.* 于 2007-01-05 07:28:34发表:
Well done!
play internet poker online | poker game free | free blackjack games | free gambling games | poker free | poker sites | gambling online | gambling poker machine | poker machines | online holdem
72.232.250.* 于 2007-01-05 07:28:09发表:
Nice site!
download casino | play free roulette | online casino | poker hand | casinos online | slot machine game | world series of poker | online video poker | free texas holdem | online gambling holdem
65.110.43.* 于 2007-01-05 07:27:55发表:
Good design!
slot games | poker stars | playing roulette | empire poker | easy online real bingo | free monopoly slots | free online poker | poker games | free on line games | free poker websites
72.232.92.* 于 2007-01-04 07:19:25发表:
Well done!
free texas hold em | 10 best online casinos | poker accept usa | online poker review room | free joker poker | bingo games | free online casino games | new online casinos | play free blackjack | poker open to us
72.232.93.* 于 2007-01-04 07:18:38发表:
Thank you!
crazy game of poker | slot games | money poker | free roulette | poker on line | online hold em | poker hand | online casinos | caribbean poker online | sim slots
72.232.250.* 于 2007-01-04 07:17:39发表:
Thank you!
no limit holdem | play internet poker online | best online poker room | play free slot machines | best casinos | play free cleopatra slots online | free slots on line | online bingo | play black jack | free slots download
65.110.43.* 于 2007-01-04 07:17:08发表:
Nice site!
best internet poker | poker tour | slots online | free online texas holdem | free play slots | free slot downloads | download free poker games | free play slot machines | slots for free | holdem poker texas
72.232.250.* 于 2007-01-04 07:16:13发表:
Thank you!
poker games online | free monopoly slots | playing roulette | strip blackjack | real money poker | party poker bonus | online casino slots | play free slot machine game | texas holdem poker online | poker review star
72.232.250.* 于 2007-01-02 21:31:10发表:
Good design!
free casinos | free roulette games | slots for fun | casino free games | gambling game | poker game | best casinos | free casino games online | video poker machines | blackjack online
65.110.43.* 于 2007-01-02 21:31:09发表:
Thank you!
free slot machine | play free slot machines | monopoly slot machine | keno | poker for us players | money poker | online casino | play poker online | multi hand poker | slot games
65.110.43.* 于 2007-01-02 21:31:00发表:
Good design!
play roulette | poker hands | download poker | download party poker | gambling machines | online poker rooms | free slots on line | slot games free | hold em poker | online bingo
72.232.93.* 于 2007-01-02 21:30:56发表:
Good design!
play roulette | poker hands | download poker | download party poker | gambling machines | online poker rooms | free slots on line | slot games free | hold em poker | online bingo
72.232.250.* 于 2007-01-02 21:30:27发表:
Nice site!
caribbean stud poker | online poker game | machine games | poker tour | free blackjack online | free blackjack games | no download no deposit casinos | best online casinos | playing roulette | poker tournament
72.232.93.* 于 2007-01-02 21:30:27发表:
Good design!
play roulette | poker hands | download poker | download party poker | gambling machines | online poker rooms | free slots on line | slot games free | hold em poker | online bingo
65.110.43.* 于 2007-01-02 21:29:53发表:
Nice site!
cleopatra slots | gamble poker | slots games | texas hold em | card poker | poker texas holdem | slot online | playing poker | blackjack game | play bingo online
72.232.93.* 于 2007-01-01 18:21:55发表:
Thank you!
online gambling holdem | best casino online | poker hand | video poker free | poker stars download | free black jack | online bingo games | 10 best online casinos | slim slots | strip black jack
72.232.250.* 于 2007-01-01 18:21:42发表:
Great work!
poker hold em | free casino games online | free bingo games | casino royale | online roulette | no deposit bingo online | free slots games | games slots | star poker | free three card poker
65.110.43.* 于 2007-01-01 18:21:30发表:
Good design!
download free poker games | free online slots | free money casinos | sims slots | free slot machine | casino slots | strip blackjack | free poker download | free casino online | blackjack free games
72.232.250.* 于 2007-01-01 18:21:28发表:
Thank you!
keno online | no download slots | poker room rating | best casino bonus | online gambling bonuses | texas holdem | play texas holdem | live poker | blackjack free | free poker game download
72.232.250.* 于 2007-01-01 18:21:13发表:
Good design!
poker texas holdem | playing poker | download party poker | play casino game | free online poker games | free slots download | poker games | poker usa | crazy game of poker | free casino
65.110.43.* 于 2006-12-31 18:42:07发表:
Good design!
poker site us | poker games | free on line slots | online poker reviews | internet casino gambling online | no limit holdem | online casino slots | poker review star | free casino slots | poker room rating
72.232.250.* 于 2006-12-31 18:41:51发表:
Nice site!
download party poker | playing poker | play slot machines for free | slot machine game | flash casinos | casinos with no deposit | free poker | free play slots | no download slots | poker tournament
65.110.43.* 于 2006-12-31 18:41:46发表:
Thank you!
poker on line | internet casino poker | draw poker | slot games | free slot | online poker us | play blackjack online | free poker tournaments | poker hold em | sim slots
72.232.250.* 于 2006-12-31 18:41:40发表:
Thank you!
best poker sites | keno games | play blackjack free | three card poker | gamble poker | play bingo | online gambling holdem | no deposit casinos | online casinos | online poker
72.232.93.* 于 2006-12-31 18:41:33发表:
Great work!
free slot machine | best online casinos | flash casino games | internet casino gambling | play bingo online | play poker for free | casino bonuses | no deposit bonus casinos | slots online | poker texas hold em
72.232.93.* 于 2006-12-30 18:36:15发表:
Good design!
playing poker | free poker games | play free blackjack online | poker rooms | free casinos | blackjack software | free bingo cards | video poker free | casino game download | monopoly slot machine
72.232.93.* 于 2006-12-30 18:36:13发表:
Good design!
online gaming | play free blackjack | casino online | internet gambling sites | on line casinos | slots online | video slot machines | play free roulette | card game poker | internet poker room
72.232.93.* 于 2006-12-30 18:35:52发表:
Nice site!
best internet poker | full tilt poker | world series poker | free texas hold em | play internet poker online | poker software | free online slots | online bingo games | casinos online | russian roulette game
72.232.93.* 于 2006-12-30 01:13:43发表:
Great work!
free casinos | holdem poker | online slot machines | free casino money | free casino slots | planet poker | poker texas hold em | black jack free | poker us welcome | no download casino
72.232.93.* 于 2006-12-30 01:13:29发表:
Great work!
free casinos | holdem poker | online slot machines | free casino money | free casino slots | planet poker | poker texas hold em | black jack free | poker us welcome | no download casino
72.232.93.* 于 2006-12-30 01:12:32发表:
Well done!
casino royale | casino portal | card game poker | internet casino poker | poker games free | casino games online | poker party | poker accepting americans | poker directory | free money casino