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