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