经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.21.40.* 于 2007-04-06 13:08:34发表:
Thank you!
no deposit online casinos | free roulette games | texas hold em | free online blackjack | free slots downloads | free slots online | free video poker | free slots download | free slot machines | casino game download
72.21.40.* 于 2007-04-06 13:07:50发表:
Nice site!
free online texas hold em | noble poker | poker free download | free strip black jack | us poker sites | online casino | games online | free play slots | online gambling | online slots free
72.21.40.* 于 2007-04-06 13:07:10发表:
Well done!
new no deposit online casinos | poker for fun | no deposit casino bonus | online holdem | free poker sites | strip blackjack game | free video slots | bingo games | free online video slots | video slot machines
72.21.40.* 于 2007-04-06 13:06:25发表:
Thank you!
slot games free | slot machines games | free casino online | russian roulette game | internet casino games | no deposit bingo | free slot | play texas holdem online | casino free | free games on line
65.110.43.* 于 2007-04-05 13:54:46发表:
Good design!
free ringtones for tracfones | hindi ringtone hindi ringtone
65.110.43.* 于 2007-04-04 13:06:58发表:
Nice site!
free motorola downloads | free ringtones for cellular south | ringtones | free phone ringtones | free ctu ringtone | ringtone midi | free ringtones for t-mobile | suncom ringtones | ringtones for motorola q | free polyphonic ringtones
65.110.43.* 于 2007-04-04 13:06:09发表:
Good design!
absolutely free ringtones | voice ringtones | free wav ringtones | ringtone jukebox | mtv ringtones | free tmobile ringtones | free star wars ringtones | free real ringtones for cingular | sprint phones | free us cellular ringtones
65.110.43.* 于 2007-04-04 13:05:44发表:
Thank you!
ringtone creator | verizon free ringtones | free nextel ringtones | free ringtones alltel | free cingular real ring tone | free lg ringtones | free sprint pcs ringtones | real tone ringtones | crazy frog ringtones | nokia ringtones
65.110.43.* 于 2007-04-04 13:05:27发表:
Thank you!
composer ringtones | lg free ringtones | free midi ringtones | free motorola ringtone downloads | cellular one ringtones | free anime | free ringtone download | free christian ringtones | cisco ringtones | free cell phone ringtones
65.110.43.* 于 2007-04-04 13:05:05发表:
Thank you!
mp3 ringtone download | free mp3 ringtone downloads | ringtone mp3 | samsung free ringtones | free alltel ringtones | 24 ring tone | free ringtones for cricket | free boost mobile ringtones | online ringtone converter | motorola keypress ringtones
72.232.250.* 于 2007-04-03 12:18:06发表:
Thank you!
roulette | texas holdem online | slot machines | free online slots games | no deposit casinos | online poker sites | video poker machines | play bingo online | online texas hold em | free slots no download
65.110.43.* 于 2007-04-03 12:17:30发表:
Nice site!
free blackjack | play slots for free | new no deposit casinos | free blackjack game | video slot games | free casino bonus | keno online | free slot games no download | pokerstars download | poker games online
65.110.43.* 于 2007-04-03 12:17:11发表:
Great work!
free slot machine games | play slot machines for free | omaha poker | games download | free games on line | free black jack game | black jack games | free on line poker | casino free games | free slots machines
72.232.250.* 于 2007-04-03 12:16:50发表:
Well done!
3 card poker | free poker game | best bonus casino | poker on line | online bingo | play free slot machines | gambling machines | free slot machines | online black jack | online poker games
65.110.43.* 于 2007-04-03 12:16:37发表:
Thank you!
free online games | play free online slots | casino deposit bonus | online free poker | fun slots | play casino games | free money no deposit casinos | play texas hold em | play roulette free | texas holdem
72.232.250.* 于 2007-04-02 16:28:54发表:
Nice site!
strip blackjack online | slots download | free online bingo | online games | strip blackjack | free slots | russian roulette game | online gambling sites | free online slots no download | joker poker
65.110.43.* 于 2007-04-02 16:28:35发表:
Great work!
texas holdem | online bingo games | slot machine free | live poker | free no deposit casinos | blackjack online free | free money no deposit casinos | black jack download | free poker downloads | poker stars
65.110.43.* 于 2007-04-02 16:27:46发表:
Good design!
play blackjack online | online slots | free poker online | party poker | pacific poker | three card poker | internet casino | roulette | blackjack games | slot machine
65.110.43.* 于 2007-04-02 16:27:29发表:
Thank you!
online baccarat | best usa casino online | poker games | pokerstars download | free games online | slot machine software | no deposit casino bonus | black jack | online black jack | free slots downloads
72.232.250.* 于 2007-04-02 16:27:15发表:
Great work!
free online casino games | free roulette online | casino black jack | blackjack free games | texas hold em free | slim slots | play texas holdem online | free online casino game | free download poker | download free poker game
72.232.63.* 于 2007-04-01 13:47:10发表:
Thank you!
free slot game | poker star | poker web sites | play slots for free | gambling online | online poker | online casino bonus | poker machines | slots for fun | slots for free
72.232.250.* 于 2007-04-01 13:46:47发表:
Great work!
free online texas hold em | omaha poker | slim slots | online roulette | free slot games online | casino bonuses | computer poker | free bingo online | free blackjack online | free online slots games
72.232.250.* 于 2007-04-01 13:46:30发表:
Good design!
download poker game | free casino online | slots download | play roulette online | poker games online | online slots | strip blackjack | bonus poker | slot machines | black jack free
72.232.63.* 于 2007-04-01 13:46:26发表:
Well done!
online poker game | roulette free games | caribbean stud poker | free online strip blackjack | play poker | casino bonus | texas hold em | free online video slots | video slot machines | cleopatra slot machine
72.232.250.* 于 2007-04-01 13:46:20发表:
Well done!
online poker game | roulette free games | caribbean stud poker | free online strip blackjack | play poker | casino bonus | texas hold em | free online video slots | video slot machines | cleopatra slot machine
72.232.63.* 于 2007-04-01 13:46:18发表:
Well done!
free bonus slots | games online | free online slot machine games | strip black jack | texas holdem free | poker game free | free casino game | keno online | on line gambling | casinos on line
72.232.63.* 于 2007-03-31 14:19:43发表:
Good design!
download casino | no download casino | video poker machines | monopoly online | free monopoly slots | play casino games | free bingo games | free slots for fun | black jack strip | free blackjack game
72.232.63.* 于 2007-03-31 14:19:21发表:
Great work!
play roulette online | three card poker | free slot machine games | monopoly slots | poker download | poker texas holdem | keno online | slim slots | multiplayer poker | internet blackjack
72.232.63.* 于 2007-03-31 14:18:48发表:
Great work!
free slot game | play roulette | online black jack | play blackjack free | texas holdem online | online gambling | online roulette game | roulette game | free online slot games | play texas hold em
72.232.63.* 于 2007-03-31 14:18:48发表:
Well done!
no deposit bonus | texas holdem | play free blackjack | internet casinos | stud poker | texas hold em | play slots | free video | games download | new no deposit casinos
65.110.43.* 于 2007-03-31 14:18:39发表:
Well done!
no deposit bonus | texas holdem | play free blackjack | internet casinos | stud poker | texas hold em | play slots | free video | games download | new no deposit casinos
65.110.43.* 于 2007-03-30 14:26:56发表:
Thank you!
no deposit bonus | free online slot games | free slot games | new no deposit online casinos | free online slots games | free casino games | video poker download | play free blackjack online | casino on net | texas hold em poker
72.232.63.* 于 2007-03-30 14:26:30发表:
Good design!
games online | free slot machine games | online free slots | play poker for free | poker for free | play free blackjack | roulette game | free online black jack | online poker game | slots free
65.110.43.* 于 2007-03-30 14:25:32发表:
Thank you!
poker stars download | free internet poker | free online casino | free strip blackjack | no deposit online casino | free casinos | free bonus slots | deposit bonus casino | free online texas holdem | texas holdem
65.110.43.* 于 2007-03-30 14:24:32发表:
Great work!
free slot machines | online gambling | on line casinos | flash casinos | black jack online | free online slots | online free roulette | free blackjack game | free slot machines games | casino games free
72.232.250.* 于 2007-03-30 14:24:13发表:
Great work!
game slot | free slots on line | stud poker | video slot | casino free game online | free slots downloads | texas holdem poker | free roulette online | free poker game | poker texas
65.110.43.* 于 2007-03-29 11:52:57发表:
Good design!
star poker | online poker games | online black jack | blackjack download | free black jack games | poker web sites | blackjack games | free casino game | free slot game | games slots
65.110.43.* 于 2007-03-29 11:52:34发表:
Great work!
free video poker | new no deposit casino | online roulette game | online black jack game | free play slots | slot games free | free sims slots | play slots | play bingo | party poker
72.232.250.* 于 2007-03-29 11:52:05发表:
Thank you!
usa online casino | blackjack free games | texas holdem free | download free poker games | download poker games | games on line | play poker online | free online texas hold em | free online poker | new no deposit casinos
65.110.43.* 于 2007-03-29 11:51:47发表:
Great work!
free casino cash | strip blackjack online | video slot machine | free roulette online | online casino games | poker games download | free online slots no download | gambling games | online baccarat | party poker download