经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
0.0.0.* 于 2007-03-08 13:46:40发表:
Your web site is really helpful! Clean and loaded with info. ebay baccarat crystal online free blackjack tournament free casino cash bonus code new lake charles casino craps game program free blackjack secret free craps simulator las vegas casino slots machine american casino guide 2003 free slots machine game to download
0.0.0.* 于 2007-03-08 13:18:35发表:
gluck spiel http://gluckspielsfpu.blogspot.com gluck spiel online kasinoportal online kasinoportal http://onlinekasinoportalrfadb.blogspot.com spielautomat spielautomat http://spielautomatdfa.blogspot.com slot slot http://slotodst.blogspot.com wetten wetten http://wettenfwfaf.blogspot.com spiellobby spiellobby http://spiellobbysnalbt.blogspot.com slot machine online spielen http://slotmachineonlinespielenbetlv.blogspot.com slot machine online spielen http://casinoonnetndgoeo.blogspot.com casino onnet casino onnet gewinn spiele gewinn spiele http://gewinnspielerryovu.blogspot.com slot maschinen online spielen slot maschinen online spielen http://slotmaschinenonlinespielensrgn.blogspot.com
0.0.0.* 于 2007-03-08 11:51:47发表:
http://baccaragfwbd.blogspot.com baccara baccara http://kasinokynyll.blogspot.com kasino kasino spiel bank spiel bank http://spielbanklhf.blogspot.com http://kasinocomaeuys.blogspot.com kasinocom kasinocom kostenloses spiel kostenloses spiel http://kostenlosesspielbwngn.blogspot.com spiel bank spiel bank http://spielbankebrupa.blogspot.com slot maschine http://slotmaschinethl.blogspot.com slot maschine roulette online spielen http://rouletteonlinespielenrvuhge.blogspot.com roulette online spielen kostenloses kasino kostenloses kasino http://kostenloseskasinodtym.blogspot.com http://slotmaschinenonlinespielenoeh.blogspot.com slotmaschinen online spielen slotmaschinen online spielen
0.0.0.* 于 2007-03-08 10:50:39发表:
http://slotmaschineonlinespielenacn.blogspot.com slotmaschine online spielen slotmaschine online spielen realistisches online casino realistisches online casino http://realistischesonlinecasinogfvp.blogspot.com kasinos http://kasinosciac.blogspot.com kasinos black jack spielen http://blackjackspielenbagr.blogspot.com black jack spielen http://spielregelnspieleautomatenkpvvcn.blogspot.com spielregeln spieleautomaten spielregeln spieleautomaten http://kostenloseskasinosybkann.blogspot.com kostenloses kasinos kostenloses kasinos glucksspiel online glucksspiel online http://glucksspielonlinetsvmrw.blogspot.com spiel raum spiel raum http://spielraumwabt.blogspot.com jackpot jackpot http://jackpotdvpi.blogspot.com http://slotmaschineonlinespielentoi.blogspot.com slot maschine online spielen slot maschine online spielen
0.0.0.* 于 2007-03-08 10:38:53发表:
kostenloses spiel online kostenloses spiel online http://kostenlosesspielonlineorh.blogspot.com gambling online gambling online http://gamblingonlineehwo.blogspot.com casino onnet http://casinoonnetowiul.blogspot.com casino onnet http://slotmaschinesirlw.blogspot.com slot maschine slot maschine mindesteinsatz mindesteinsatz http://mindesteinsatzuect.blogspot.com kostenlos blackjack spielen http://kostenlosblackjackspielentrs.blogspot.com kostenlos blackjack spielen gewinn spiele gewinn spiele http://gewinnspielebbdl.blogspot.com internet casinos internet casinos http://internetcasinostsrik.blogspot.com http://kostenlosblackjackspielentyum.blogspot.com kostenlos blackjack spielen kostenlos blackjack spielen online blackjack spielen http://onlineblackjackspielenkeptnb.blogspot.com online blackjack spielen
0.0.0.* 于 2007-03-08 10:38:14发表:
Thank you for creating this wonderful place on the web. betting blackjack online roulette argosy empress casino free casino slots for fun hotel casino philadelphia mississippi harrahs cherokee casino hotel boom town casino louisiana arizona casino charlies decatur hotel sim slots game sterling casino line free blackjack pocket pc
0.0.0.* 于 2007-03-08 10:11:44发表:
http://spielbanklfpmw.blogspot.com spielbank spielbank kostenloses online spiel raum kostenloses online spiel raum http://kostenlosesonlinespielraumavghuh.blogspot.com blackjack spielen http://blackjackspielenpbrvdg.blogspot.com blackjack spielen slotmachine spielen http://slotmachinespielenglp.blogspot.com slotmachine spielen spiel bank spiel bank http://spielbankufpaha.blogspot.com kasino spiele http://kasinospieleppaswn.blogspot.com kasino spiele http://slotmaschineknv.blogspot.com slot maschine slot maschine casinocom http://casinocomuvf.blogspot.com casinocom kasino website kasino website http://kasinowebsitepetfiv.blogspot.com spielregeln blackjack http://spielregelnblackjackooiyks.blogspot.com spielregeln blackjack
0.0.0.* 于 2007-03-08 09:59:55发表:
I can't wait to utilize this site even more! virtual online casino gambling poker play backgammon with the computer aol casino free game see hard rock cafe casino las vegas harrahs casino iowa slim slots affiliate casino gaming program buy roulette wheel indian casino in oregon video poker home
0.0.0.* 于 2007-03-08 09:56:32发表:
las vegas las vegas http://lasvegasleulh.blogspot.com internet kasino internet kasino http://internetkasinoasrcs.blogspot.com http://geldeinsatzrhpt.blogspot.com geldeinsatz geldeinsatz kostenloses online spiel kostenloses online spiel http://kostenlosesonlinespielepppd.blogspot.com gewinne gewinne http://gewinneeus.blogspot.com http://bettingcykbm.blogspot.com betting betting hochsteinsatz hochsteinsatz http://hochsteinsatzrrrn.blogspot.com http://geldgewinnegvpyg.blogspot.com geld gewinne geld gewinne spiel online kasino spiel online kasino http://spielonlinekasinotatla.blogspot.com casino spiele http://casinospielemvvowd.blogspot.com casino spiele
65.110.43.* 于 2007-03-08 09:48:31发表:
Great work!
free online poker | cleopatra slot machine | free online slots | free bingo | casino bonuses | play texas holdem free | absolute poker | free bingo online | gambling machines | free money casino
72.232.250.* 于 2007-03-08 09:47:23发表:
Nice site!
play free blackjack online | free black jack games | free online gambling | slot machine free | poker free | play roulette for free | free online roulette | no deposit online casino | poker star | video slot machine
65.110.43.* 于 2007-03-08 09:46:38发表:
Great work!
free games online | online casino | free online slots no download | online blackjack free | free slim slots | free video poker | play blackjack online | play free roulette | online games | free poker money
65.110.43.* 于 2007-03-08 09:45:30发表:
Well done!
free slot games no download | online free blackjack | blackjack online | free poker downloads | online texas hold em | star poker | online roulette | no deposit casino bonus | poker software | free online slot machine games
72.232.63.* 于 2007-03-08 09:45:12发表:
Thank you!
free multi line slots | no deposit bonus casinos | online poker games | download poker | download casino games | on line casinos | video poker | pacific poker | free slot machine games | roulette game
0.0.0.* 于 2007-03-08 09:43:32发表:
Very nice website. We're glad to see that someone is making such a serious effort. Thank you! play money online roulette free casino sims slots hard rock cafe casino las vegas slim slots casino argosy casino kc en language roulette wheel craps table blue print bar machine poker video wholesaler player development casino no deposit casino coupon code
0.0.0.* 于 2007-03-08 09:10:40发表:
GREAT IDEA!!! Thanks and keep up the good work. ameristar casino hotel council bluff best casino new baccarat crystal stemware gambling online party poker roulette foxwoods casino address bus to mohegan sun casino free slots win cash top online poker casino yahoo casino game casino free sands slots
0.0.0.* 于 2007-03-08 09:07:46发表:
Great work! casino falls lodge niagara play for fun online slots mail slots basket internet craps slots online blackjack picture table spa casino palm springs ca best 900 pay online casino free 20 line slots machine casino choctaw mississippi
0.0.0.* 于 2007-03-08 09:05:49发表:
Amazing site! niagara falls view casino cartoon free game slots xxx free casino cash no deposit required bonus casino code nd online rtg blackjack play rule free strip blackjack xxx gambling pennsylvania slots best slots machine bingo gaming club online casino
0.0.0.* 于 2007-03-08 08:12:06发表:
This site is wonderful. best online casino sports betting free blackjack download venetian hotel and casino las vegas backgammon checkers backgammon custom set the game backgammon to play for free casino in vegas craps table design casino cash online jackpot party slots machine
0.0.0.* 于 2007-03-08 07:11:42发表:
I don't know how long it has been up and running but I just love this website! 3 free machine reel slots blackjack book hard rock casino in hollywood fl 18 california casino argosy casino joliet mail slots hardware casino free money play poker accommodation casino niagara australia casino line copper mail slots
0.0.0.* 于 2007-03-08 06:47:53发表:
Great site! I find it very helpful. how to make a roulette wheel casino hard pool rock online progressive slots video vegas red casino casino poker rule best casino com gambling online casino nj resort tropicana edgewater hotel and casino sunset station casino casino hotel las sands vegas
0.0.0.* 于 2007-03-08 03:09:52发表:
realisitisches kasino realisitisches kasino http://realisitischeskasinohilny.blogspot.com kostenloses online spiel kostenloses online spiel http://kostenlosesonlinespielllyc.blogspot.com http://kostenlosekasinospielekuo.blogspot.com kostenlose kasino spiele kostenlose kasino spiele spiel online spiel online http://spielonlinevpr.blogspot.com las vegas http://lasvegaserwbe.blogspot.com las vegas einsatze einsatze http://einsatzekoi.blogspot.com http://spielbdwkv.blogspot.com spiel spiel http://bingovgrryg.blogspot.com bingo bingo casino on net casino on net http://casinoonnetgkluo.blogspot.com wetten wetten http://wettenbsc.blogspot.com
0.0.0.* 于 2007-03-08 01:37:56发表:
I have already found your site to be very helpful. It is especially nice for newcomers as well as people that have been here for a while. I am sure I will come and check it often. casino rio grande hotel and casino in atlantic city nj play for free jackpot party slots add bonus casino link casino game free online sicbo online bonus feature slots online blackjack no download monte carlo hotel and casino gold coast hotel and casino station casino kansas city
0.0.0.* 于 2007-03-08 01:37:52发表:
Thank you. This has a great potential. meilleures salles de jeux jeu de hasard 888 jeu salles de jeux casino jeu jouez au casino craps casino internet casino net
0.0.0.* 于 2007-03-08 01:21:41发表:
slots online http://slotsonlinegtpc.blogspot.com slots online gambling casino online gambling casino online http://gamblingcasinoonlinehyn.blogspot.com blackjack game http://blackjackgameagu.blogspot.com blackjack game online slots online slots http://onlineslotshka.blogspot.com craps craps http://crapsnng.blogspot.com slots online slots online http://slotsonlinewidbwp.blogspot.com best casino best casino http://bestcasinotvavub.blogspot.com play blackjack play blackjack http://playblackjackmevk.blogspot.com free slots game free slots game http://freeslotsgamemcyg.blogspot.com play keno online play keno online http://playkenoonlinedkwcr.blogspot.com
220.226.63.* 于 2007-03-08 00:39:12发表:
online casino gambling http://onlinecasinogamblinghrvr.blogspot.com online casino gambling internet keno http://internetkenorulv.blogspot.com internet keno casino on the net casino on the net http://casinoonthenetgmphy.blogspot.com free blackjack free blackjack http://freeblackjacklnedua.blogspot.com roulette online roulette online http://rouletteonlineowlnr.blogspot.com roulette http://rouletteavy.blogspot.com roulette jack black jack black http://jackblackyrphdy.blogspot.com free casino game free casino game http://freecasinogameoapc.blogspot.com slots game slots game http://slotsgameposk.blogspot.com play craps play craps http://playcrapsebar.blogspot.com
0.0.0.* 于 2007-03-08 00:29:07发表:
free keno games free keno games http://freekenogamesrchdf.blogspot.com http://playcrapsonlinefreegkcngw.blogspot.com play craps online free play craps online free online casino bonus online casino bonus http://onlinecasinobonusayle.blogspot.com online casino http://onlinecasinofsn.blogspot.com online casino online casino game online casino game http://onlinecasinogamentcnay.blogspot.com keno keno http://kenodoi.blogspot.com casino on line casino on line http://casinoonlinepuatb.blogspot.com best online casino gambling http://bestonlinecasinogamblinglhw.blogspot.com best online casino gambling jack black jack black http://jackblackphtruk.blogspot.com http://casinotoe.blogspot.com casino casino
0.0.0.* 于 2007-03-08 00:21:19发表:
GREAT IDEA!!! Thanks and keep up the good work. on line casino gaming baccarat france casino game rule casino machine slots stands book casino internet online sport casino cpm rama play online slots craps table build your own casino games backgammon board setup
0.0.0.* 于 2007-03-07 23:50:46发表:
blackjack blackjack http://blackjackesmp.blogspot.com casino gaming http://casinogamingmdtf.blogspot.com casino gaming internet casino internet casino http://internetcasinokvm.blogspot.com free backgammon free backgammon http://freebackgammonppv.blogspot.com blackjack online http://blackjackonlinecrl.blogspot.com blackjack online casino on the net casino on the net http://casinoonthenetcwp.blogspot.com http://freecasinogamesyhh.blogspot.com free casino games free casino games jack black jack black http://jackblacktikmnh.blogspot.com free online keno http://freeonlinekenovuf.blogspot.com free online keno http://crapsonlinecbhd.blogspot.com craps online craps online
200.59.145.* 于 2007-03-07 23:39:16发表:
Good work. grand casino mississippi baldwin mail slots casino on line career casino niagara test online casino for free best slots to play argosy casino kc bar machine poker video wholesaler free no deposit bonus online casino mohegan sun casino conn
0.0.0.* 于 2007-03-07 23:38:16发表:
Good work. grand casino mississippi baldwin mail slots casino on line career casino niagara test online casino for free best slots to play argosy casino kc bar machine poker video wholesaler free no deposit bonus online casino mohegan sun casino conn
0.0.0.* 于 2007-03-07 23:04:05发表:
best online casino gambling best online casino gambling http://bestonlinecasinogamblingovo.blogspot.com blackjack online http://blackjackonlineggtt.blogspot.com blackjack online blackjack http://blackjacktguya.blogspot.com blackjack http://freevideopokereow.blogspot.com free video poker free video poker free slots machine http://freeslotsmachineartbra.blogspot.com free slots machine free online slots free online slots http://freeonlineslotsmniswr.blogspot.com free slots http://freeslotsokbh.blogspot.com free slots play bingo online play bingo online http://playbingoonlinepdeeg.blogspot.com http://onlinecasinokfn.blogspot.com online casino online casino free blackjack free blackjack http://freeblackjackbcre.blogspot.com
200.6.208.* 于 2007-03-07 23:03:18发表:
how to play craps how to play craps http://howtoplaycrapsmykg.blogspot.com http://playkenoonlineydu.blogspot.com play keno online play keno online video poker http://videopokerpikwn.blogspot.com video poker casino gamble casino gamble http://casinogambleacsble.blogspot.com internet keno internet keno http://internetkenoinmd.blogspot.com virtual casino virtual casino http://virtualcasinorvlss.blogspot.com http://internetkenoorl.blogspot.com internet keno internet keno craps rules craps rules http://crapsrulesblpwp.blogspot.com keno casino http://kenocasinooagmi.blogspot.com keno casino play free casino play free casino http://playfreecasinoeco.blogspot.com
81.80.23.* 于 2007-03-07 22:01:11发表:
Everything I have seen so far has been great. jeu de hasard jeu online top des casinos en ligne salles virtuelles de jeux gratuits top casinos en ligne meilleur casino en ligne roulette casino jeu casino net casino en line
213.240.225.* 于 2007-03-07 21:43:19发表:
I love the website! It is crisp and full of information. I really like this site I visit it often. Keep up the good work! jeu online jeu salles virtuelles de jeux gratuits bonus de casino en ligne internet casino casino jeu online gambling casino ligne jouez au casino en ligne casino france
0.0.0.* 于 2007-03-07 21:29:39发表:
I forwarded the site to over 50 people here. insulated mail slots play backgammon for money baccarat net casino casino de internet windsor casino hotel internet casino gambling game bonus free game online slots car nanuet ny racing slots blackjack card game rule south california indian casino
0.0.0.* 于 2007-03-07 21:29:07发表:
I forwarded the site to over 50 people here. insulated mail slots play backgammon for money baccarat net casino casino de internet windsor casino hotel internet casino gambling game bonus free game online slots car nanuet ny racing slots blackjack card game rule south california indian casino
0.0.0.* 于 2007-03-07 20:38:51发表:
Just wanted to tell you the web site is fantastic!!!!!!!! casino online top casinos en ligne net jeu online gambling casino france roulette salles de jeux virtuelles jeu en ligne gratuit casino on net jeu sur internet
0.0.0.* 于 2007-03-07 20:31:10发表:
Great Job! online casino black jack jeu sur internet top casinos promotions jeu casino de paris internet casino gambling jeu en ligne top casinos promotions
0.0.0.* 于 2007-03-07 20:28:33发表:
I am so glad you started this site. I think it's wonderful! jouez ligne meilleur casino en ligne casino en ligne casino net jeu de cartes jouer casino casino online gamme net jeu gamme net jeu craps