经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-03-29 11:51:33发表:
Good design!
bingo games | free bonus slots | games download | monopoly slot machine | casino free online | poker on line | sim slots | on line casinos | free online bingo games | best usa casino online
65.110.43.* 于 2007-03-28 12:04:09发表:
Good design!
sports lines | sports money | bet on basketball | baseball betting lines | ncaa basketball tournament march madness | sports betting online | nfl gambling | march madness finals | scottish league cup bet | bet gamble
65.110.43.* 于 2007-03-28 12:03:39发表:
Good design!
march madness sports | nhl futures | sports book | march madness tournament bracket | ncaa march madness odds | sports betting strategies | odds hockey | nfl lines | 07 madness march ncaa | march madness ncaa bracket
72.232.63.* 于 2007-03-28 12:03:12发表:
Good design!
betting web site | sports betting rules | sports handicapping | sport gambling | football betting lines | college football odds | denmark sas ligaen bet | sporting bets | betting on line | odds ncaa football
72.232.63.* 于 2007-03-28 12:02:55发表:
Good design!
nascar odds odds | bet gambling | march madness | college football sports | vegas odds on college basketball | gamble sports bet online | online betting | nfl betting lines | sports baseball | super bowl bet
72.232.250.* 于 2007-03-28 12:02:37发表:
Well done!
brackets for march madness | march madness stats | football gambling | march madness blank | turkish super ligi bet | us masters odds | march madness vegas | nba picks | ncaa sports | march madness predictions
65.110.43.* 于 2007-03-27 13:41:45发表:
Nice site!
24 ring tones | free nokia downloads | ringtones wav | ringtone motorola | motorola ring tones | ringtone jukebox | ringtones for nextel | arabic ringtones | t mobile ringtones | polyphonic ringtone
72.232.63.* 于 2007-03-27 13:41:23发表:
Good design!
nextel ringtone | free ringtones for cingular | free us cellular ring tones | us cellular ringtones | tracfone ringtones | star wars ringtone | free anime ringtones | centennial wireless ringtones | free downloadable ringtones | free composer ringtones
65.110.43.* 于 2007-03-27 13:40:52发表:
Good design!
samsung ringtones | ringtones for suncom | free ringtone creator | free real tone ringtones | verizon ringtones free | funny ringtone | free polyphonic | us cellular ring tones | ringtones samsung | sprint ringtones
65.110.43.* 于 2007-03-27 13:40:08发表:
Great work!
free cellphone ringtones | voice ringtones | free ringtones | ringtones nokia | mobile phone ringtones | ctu ringtone verizon | free ringtones for u s cellular | u s cellular ringtones | mp3 ringtone download | motorola keypress ringtones
65.110.43.* 于 2007-03-27 13:39:33发表:
Thank you!
free ringtone | mtv ringtones | free mp3 ringtones download | free nascar ringtones | ringtones midi | mp3 ringtone converter | country music ringtones | free ringtones for cellular south | free ringtones for t-mobile | free ringtones motorola
65.110.43.* 于 2007-03-26 19:01:49发表:
Thank you!
video slot games | online holdem | video slots free | hold em poker | black jack strip | casino black jack | free slot downloads | play free slots | flash casinos | free poker sites
65.110.43.* 于 2007-03-26 19:00:12发表:
Good design!
internet gambling | download poker games | roulette game | casino slot games | strip blackjack games | casino bonus | blackjack online | slots games | poker websites | free poker game
65.110.43.* 于 2007-03-26 18:59:02发表:
Nice site!
texas holdem | play slot machines for free | free online slots no downloads | play free roulette | bonus casino free online | new casinos | black jack game | poker stars | pokerstars download | play free slot machines
65.110.43.* 于 2007-03-26 18:56:14发表:
Great work!
casino free online | play free slots online | noble poker | slot machines free | full tilt poker | poker | video slot machines | slot games | play poker for free | blackjack download
65.110.43.* 于 2007-03-26 18:55:16发表:
Great work!
slot game | free video | on line casinos | online video slots | free online gambling | free online poker games | live poker | poker web sites | poker free | poker game online
72.232.63.* 于 2007-03-25 18:34:21发表:
Good design!
play slots for fun | free poker sites | free slots downloads | texas hold em | slots of fun | sims free slots | us poker sites | free games on line | free black jack game | new online casinos
65.110.43.* 于 2007-03-25 18:32:56发表:
Great work!
download blackjack | free no deposit casino | party poker download | online slots | poker games download | no deposit casino bonus | online poker sites | free casino money | free casino games online | russian roulette game
65.110.43.* 于 2007-03-25 18:32:04发表:
Great work!
play money poker | casino games free | strip blackjack online | no deposit bingo | free roulette | slot machine software | free strip black jack | slot machines free | gambling games | internet blackjack
65.110.43.* 于 2007-03-25 18:30:47发表:
Well done!
free slots machines | online casino bonus | play slots | full tilt poker | caribbean stud poker | free casino slot games | slots free | free online roulette | aussie slots | free poker game download
72.232.63.* 于 2007-03-25 18:29:31发表:
Well done!
poker stars download | online casinos | online blackjack free | free bingo games | casino games | online slots free | online strip blackjack | free online texas holdem | free poker on line | keno online
65.110.43.* 于 2007-03-24 14:03:23发表:
Thank you!
free slot games no download | play texas holdem free | poker for fun | free online slots games | online free poker | sims free slots | free online texas hold em | free cleopatra slots | online video slots | games online
72.232.63.* 于 2007-03-24 14:02:50发表:
Thank you!
slot machine free | game slot | online poker free | empire poker | roulette games | casino black jack | gambling games | play free online slots | free online games | free casinos
65.110.43.* 于 2007-03-24 14:02:25发表:
Well done!
games download | no download slots | online blackjack free | free casino game | free poker software | free roulette online | blackjack software | free monopoly slots | play roulette online | free poker games
65.110.43.* 于 2007-03-24 14:02:05发表:
Thank you!
flash casino games | casino free online | online casinos | free casino slot | world series of poker | play bingo | cleopatra slot machine | texas holdem | aussie slots | black jack free
72.232.63.* 于 2007-03-24 14:01:52发表:
Good design!
download poker games | free online bingo games | internet poker | casino slot games | free casino money | free play slot machines | new no deposit casinos | bingo games | absolute poker | free texas holdem
65.110.43.* 于 2007-03-23 13:11:21发表:
Nice site!
slots free | casino poker | free cleopatra slots | download blackjack | texas holdem free online | free roulette | live poker | video poker download | free online slot machine games | free casino bonus
65.110.43.* 于 2007-03-23 13:10:14发表:
Good design!
online blackjack free | free blackjack online | no deposit casinos | casino on line | free online poker game | party poker download | free slots | video poker | casino online | strip blackjack
65.110.43.* 于 2007-03-23 13:09:13发表:
Nice site!
free black jack | roulette | casino games | free money casinos | casino bonuses | free sims slots | play slot machines for free | free slots online | free strip black jack | free money no deposit casinos
65.110.43.* 于 2007-03-23 13:08:55发表:
Good design!
download poker game | free monopoly online | online free slots | play roulette | no deposit casino bonus | online gambling | cleopatra slot machine | new free money online casinos | free online gambling | slot machine free
72.232.63.* 于 2007-03-23 13:08:43发表:
Good design!
play slot machines | russian roulette game | multiplayer poker | bonus poker | free slot machines | free slots | free joker poker | online roulette game | download casino games | poker for free
65.110.43.* 于 2007-03-22 19:36:34发表:
Well done!
pokerstars download | free blackjack game | play slots for fun | internet casinos | best bonus casino | games on line | free fun slots | no download casino | free monopoly online | flash casino games
65.110.43.* 于 2007-03-22 19:35:55发表:
Nice site!
free slots | free slot machine | video poker free | casino slot games | online poker | star poker | on line casinos | game slot | pacific poker | gambling online
65.110.43.* 于 2007-03-22 19:35:23发表:
Well done!
strip black jack | play slot machines | slots for fun | no deposit bingo | play free online slots | free video slot games | free slots games | online strip blackjack | slots on line | black jack game
72.232.63.* 于 2007-03-22 19:35:00发表:
Good design!
free poker online | strip blackjack game | free texas holdem online | free texas holdem poker | video slot | free roulette | casino game | free black jack game | free poker game | poker texas holdem
72.232.63.* 于 2007-03-22 19:34:44发表:
Good design!
texas holdem | free slots download | casino games | free poker sites | video slot machines | play roulette | free texas holdem | casino on line | free on line poker | online free blackjack
65.110.43.* 于 2007-03-21 14:12:16发表:
Great work!
online free slots | paradise poker | free slot games | online bingo | poker web sites | poker stars | free slot games online | poker texas holdem | play roulette for free | free poker game download
72.232.63.* 于 2007-03-21 14:11:44发表:
Thank you!
omaha poker | blackjack for free | blackjack software | video poker free | free slot machines games | free slots for fun | online poker usa | new no deposit casinos | sims free slots | poker downloads
65.110.43.* 于 2007-03-21 14:11:01发表:
Great work!
online holdem | world series of poker download | blackjack download | free online bingo games | poker sites | new casinos | online black jack | online video slots | new online casinos | casino bonuses
65.110.43.* 于 2007-03-21 14:09:58发表:
Great work!
roulette game | download free poker game | internet casino | download casino games | free slots on line | poker free | download poker game | free online games | roulette free | casino slot games