经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-03-13 04:05:07发表:
Thank you!
video slot machine | texas hold em poker | free slot machine games | black jack free | free poker games | free fun slots | free bonus slots | free slot machine | new online casinos | free online casino slots
72.232.250.* 于 2007-03-13 04:04:43发表:
Well done!
online roulette free | blackjack free | slots games | poker texas | casino online | holdem poker | free online slot machines | video poker machines | free online slots no downloads | blackjack strip
0.0.0.* 于 2007-03-12 19:50:22发表:
I don't know how long it has been up and running but I just love this website! ying yang twins ringtones selena ringtones free real ringtone free verizon ringtone mp3 ringtone gundam ringtone kid a ringtone something corporate ringtone free nextel ringtone selena ringtone
12.180.115.* 于 2007-03-12 19:48:59发表:
Please check out this website: free nokia ringtones marilyn manson ringtones young gunz ringtones eminem ringtone free verizon ringtones free real ringtones marilyn manson ringtones hotlink caller ringtone free motorola ringtone ja rule ringtone
67.19.202.* 于 2007-03-12 15:04:29发表:
Please check out this website: samsung ringtone free verizon ringtones t mobile ringtone dance last ringtone butterfly ringtone download free cingular ringtone free mp3 ringtones polyphonic ringtone eric clapton ringtone ringtones
83.16.230.* 于 2007-03-12 15:01:06发表:
Very nice website. We're glad to see that someone is making such a serious effort. Thank you! britney spears ringtones dance last ringtones celtic frost ringtones red hot chili pepper ringtone lone star ringtone madonna ringtone born lyric ringtone kiss ringtone free verizon ringtone tina turner ringtones
0.0.0.* 于 2007-03-12 14:59:31发表:
This site is wonderful. selena ringtones free polyphonic ringtones real music ringtones real music ringtone free cell phone ringtones snoop dog ringtones real music ringtone ringtone download free cingular ringtone bright eyes ringtones jennifer lopez ringtones
72.232.250.* 于 2007-03-11 19:51:58发表:
Well done!
free casino | online poker sites | poker on line | poker game free | monopoly slot machine | free online casino slots | free black jack games | new online casinos | online poker | stud poker
65.110.43.* 于 2007-03-11 19:51:06发表:
Nice site!
play roulette | internet gambling | play free online slots | black jack games | poker machines | flash casino games | black jack game | free casino games online | free online slots no downloads | gambling sites
65.110.43.* 于 2007-03-11 19:50:33发表:
Great work!
free slot machines games | online roulette | internet casinos | free money casinos | free online slot machine | download party poker | free 3 card poker | blackjack strip | world series poker | play poker
72.232.63.* 于 2007-03-11 19:50:05发表:
Great work!
slot machine games free | online bingo games | noble poker | roulette free games | free poker money | world series of poker | free video | video slot machines | play money poker | free slot game
65.110.43.* 于 2007-03-11 19:49:49发表:
Great work!
free online slots no download | free texas holdem | texas holdem free online | casino slot games | play texas holdem online | free slot machines | poker stars download | free slots no download | on line poker | party poker
0.0.0.* 于 2007-03-11 18:52:42发表:
Excellent piece of work!! relient k ringtones samsung ringtones verizon wireless ringtone red hot chili pepper ringtones elvis presley ringtone selena ringtones darude ringtone selena ringtone ringtone mp3 ringtones
0.0.0.* 于 2007-03-11 18:52:25发表:
It is very informative easily navigated and attractive. boyz east ringtone side 50 cent ringtone free nokia ringtones drive me crazy ringtone eric clapton ringtones jennifer lopez ringtone the flaming lip ringtones remind ringtone jennifer lopez ringtones eminem ringtones
0.0.0.* 于 2007-03-11 18:52:07发表:
Everything I have seen so far has been great. new ringtones kid a ringtone cingular ringtones drive me crazy ringtones dave hollister ringtone psychedelic furs ringtone linkin park ringtone mosquito ringtone marilyn manson ringtones remind ringtone
72.232.250.* 于 2007-03-10 19:54:27发表:
Thank you!
slots games | free poker online | free slot machine downloads | online texas holdem | absolute poker | us poker sites | free slots downloads | computer poker | casino slots | play black jack
65.110.43.* 于 2007-03-10 19:53:32发表:
Thank you!
russian roulette game | slot machine games | roulette | free online slot machines | free slot machine games | free texas holdem | online blackjack free | free online gambling | casino free | poker game download
65.110.43.* 于 2007-03-10 19:53:04发表:
Good design!
slot machine software | online casino games | full tilt poker | free slot downloads | play slots | monopoly slots | russian roulette | games slots | poker games | play blackjack online
65.110.43.* 于 2007-03-10 19:52:54发表:
Nice site!
internet blackjack | blackjack for free | best poker sites | free slots | online poker | casino game download | poker sites | free slot machines | free poker on line | online texas hold em
72.232.250.* 于 2007-03-10 19:52:30发表:
Well done!
free video | new online casinos | casino on net | video poker | free fun slots | free casino cash | free 3 card poker | free online strip blackjack | sims slots | play roulette
72.232.63.* 于 2007-03-09 18:24:43发表:
Nice site!
Free Casino Online | Casino free games | Russian roulette game | Pokerstars Download | Poker on line | Free Roulette Games | Poker on line | Video Poker Download | Free Slot Machine | Download poker games
65.110.43.* 于 2007-03-09 18:24:07发表:
Good design!
Best Online Casinos | Slot Machine Games | Free poker downloads | Free Casino Money | Play roulette online | Online roulette free | Poker Stars Download | Free Poker Online | New Free Money Online Casinos | Online Poker Games
72.232.250.* 于 2007-03-09 18:23:33发表:
Good design!
Online roulette | Slim Slots | Poker Software | Free Online Strip Blackjack | Free Poker Software | Free Casino Bonus | Casino Game | Free Monopoly Online | Play roulette | Slots Of Fun
65.110.43.* 于 2007-03-09 18:23:13发表:
Great work!
Poker Free Download | No Download Slots | Online Casino Games | Caribbean poker | Free casino slot games | Casino Slot Games | Poker game download | Slots Of Fun | Free Bingo Online | Poker Sites
65.110.43.* 于 2007-03-09 18:22:57发表:
Thank you!
Online Free Poker | Planet Poker | Blackjack Game | Free Slot Play | Russian roulette games | New casinos | Blackjack Online Free | Casino on net | Free Online Slot Machines | Black Jack Games
163.20.137.* 于 2007-03-09 13:58:31发表:
http://nodepositcasinoactpge.blogspot.com no deposit casino no deposit casino casino on net casino on net http://casinoonnetywlgug.blogspot.com online blackjack http://onlineblackjackwfp.blogspot.com online blackjack internet casino http://internetcasinodby.blogspot.com internet casino internet keno internet keno http://internetkenotcvby.blogspot.com http://gamblingcasinoonlineslm.blogspot.com gambling casino online gambling casino online blackjack online http://blackjackonlinevwcpgs.blogspot.com blackjack online http://freeonlinecasinoftiv.blogspot.com free online casino free online casino slots http://slotsuvylio.blogspot.com slots slots slots http://slotswii.blogspot.com
213.240.225.* 于 2007-03-09 13:57:53发表:
http://nodepositcasinoactpge.blogspot.com no deposit casino no deposit casino casino on net casino on net http://casinoonnetywlgug.blogspot.com online blackjack http://onlineblackjackwfp.blogspot.com online blackjack internet casino http://internetcasinodby.blogspot.com internet casino internet keno internet keno http://internetkenotcvby.blogspot.com http://gamblingcasinoonlineslm.blogspot.com gambling casino online gambling casino online blackjack online http://blackjackonlinevwcpgs.blogspot.com blackjack online http://freeonlinecasinoftiv.blogspot.com free online casino free online casino slots http://slotsuvylio.blogspot.com slots slots slots http://slotswii.blogspot.com
213.240.225.* 于 2007-03-09 13:14:42发表:
I love everything about your site. casinos en ligne gambling black jack jeu gratuit jeu meilleurs casinos en ligne bonus des casinos en ligne les meilleurs casinos en ligne jouer casino casinos en ligne
89.108.83.* 于 2007-03-09 09:47:24发表:
Nice site man! jackson indian casino free casino credit blackjack for fun louisiana casino hotel play station casino bonus casino code coupon free rtg harrahs casino louisiana pokerroom online craps betting black casino jack backgammon direction
4.79.245.* 于 2007-03-09 09:28:41发表:
I will recommend it! louisiana casino hotel sim slots and poker vegas casino craps free online play riviera hotel and casino in las vegas planche a roulette casino niagara jobs best paying online casino niagara falls view casino resort casino employment falls niagara
213.240.225.* 于 2007-03-09 02:02:00发表:
casinos im internet casinos im internet http://casinosiminternetssn.blogspot.com slot machine slot machine http://slotmachinevau.blogspot.com http://lasvegasolh.blogspot.com las vegas las vegas slotmachine spielen http://slotmachinespielenwde.blogspot.com slotmachine spielen online spielkasino online spielkasino http://onlinespielkasinoyyvr.blogspot.com videopoker http://videopokertngp.blogspot.com videopoker lucky lucky http://luckywgbv.blogspot.com faires spielen http://fairesspielenlfl.blogspot.com faires spielen atlantic city http://atlanticcityancgad.blogspot.com atlantic city glucksspielgesellschaft http://glucksspielgesellschaftnys.blogspot.com glucksspielgesellschaft
213.180.140.* 于 2007-03-09 00:30:55发表:
http://relientkringtoneffrl.blogspot.com relient k ringtone relient k ringtone http://paydaycashadvancenewyorkoldfb.blogspot.com payday cash advance new york payday cash advance new york fast cash advance http://fastcashadvancesnbbs.blogspot.com fast cash advance free verizon ringtones free verizon ringtones http://freeverizonringtonesckcdv.blogspot.com free polyphonic ringtone download free polyphonic ringtone download http://freepolyphonicringtonedownloaddlsch.blogspot.com dance last ringtones dance last ringtones http://dancelastringtonestlb.blogspot.com cash advance store cash advance store http://cashadvancestorecbam.blogspot.com free kyocera ringtone http://freekyoceraringtoneumeep.blogspot.com free kyocera ringtone maxis caller ringtones maxis caller ringtones http://maxiscallerringtoneskrcu.blogspot.com easy online cash advance http://easyonlinecashadvanceomv.blogspot.com easy online cash advance
0.0.0.* 于 2007-03-08 23:27:08发表:
Thank you for creating this wonderful place on the web. las vegas slots machine online canada casino falls hotel niagara bonus casino code newest online black casino island jack pogo backgammon download free online play betting online roulette casino rama ontario canada ameristar casino ms vicksburg horseshoe casino in hammond indiana play free slim slots
81.25.160.* 于 2007-03-08 20:25:01发表:
I am so glad you started this site. I think it's wonderful! turning stone casino verona ny seminole casino hollywood online video poker bonus blackjack game rule indian casino directory the palace indian gaming casino bus casino niagara toronto online casino player atlantic baccarat casino city mini blackjack mountain
0.0.0.* 于 2007-03-08 18:55:40发表:
Please check out this website: casino france casinos jeu de cartes roulette jeu sur internet jeu en ligne gratuit bonus des casinos en ligne jeu de cartes jeu gratuit jouez au casino en ligne
0.0.0.* 于 2007-03-08 18:30:24发表:
Your site is helpful. salles de jeux virtuelles casino jeu internet casino casino partouche online casino black jack meilleures promotions en ligne salles de jeux casino online 888
0.0.0.* 于 2007-03-08 15:42:09发表:
gambling online http://gamblingonlinegaflfl.blogspot.com gambling online black jack spielen black jack spielen http://blackjackspielenwbsv.blogspot.com online kasino http://onlinekasinowisl.blogspot.com online kasino spielen kasino spielen kasino http://spielenkasinovmm.blogspot.com betting http://bettingimgawr.blogspot.com betting spiel erlebnis spiel erlebnis http://spielerlebniswyerka.blogspot.com online spiel automaten online spiel automaten http://onlinespielautomatenohopot.blogspot.com online slotmaschine online slotmaschine http://onlineslotmaschinevrt.blogspot.com gambling http://gamblingbcbrc.blogspot.com gambling http://gamblingbwlvw.blogspot.com gambling gambling
210.196.205.* 于 2007-03-08 15:41:51发表:
gambling online http://gamblingonlinegaflfl.blogspot.com gambling online black jack spielen black jack spielen http://blackjackspielenwbsv.blogspot.com online kasino http://onlinekasinowisl.blogspot.com online kasino spielen kasino spielen kasino http://spielenkasinovmm.blogspot.com betting http://bettingimgawr.blogspot.com betting spiel erlebnis spiel erlebnis http://spielerlebniswyerka.blogspot.com online spiel automaten online spiel automaten http://onlinespielautomatenohopot.blogspot.com online slotmaschine online slotmaschine http://onlineslotmaschinevrt.blogspot.com gambling http://gamblingbcbrc.blogspot.com gambling http://gamblingbwlvw.blogspot.com gambling gambling
0.0.0.* 于 2007-03-08 14:39:48发表:
What a great idea! players island riverboat casino mohegan sun casino employment the game backgammon to play for free argosy casino indiana riverboat new fallsview casino morongo indian casino atlantic city casino buffets video poker trainer caesar casino atlantic city best paying online casino
200.89.177.* 于 2007-03-08 14:31:24发表:
We read about your website everywhere and think that it's a wonderful idea. fortune lounge online casino play free casino card game casino resort east chicago evansville indiana casino casino poker chips for sale club player casino bonus code free cash coupon casino free roulette on line betting blackjack online roulette hard rock casino hollywood florida