经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.36.192.* 于 2007-06-21 07:54:13发表:
Well done!
no deposit bonus casinos | online casino games | slots download | free black jack game | download casino | play texas holdem | strip blackjack free | games download | free video slots | free roulette
72.36.192.* 于 2007-06-21 07:53:05发表:
Thank you!
online slots free | games online | free slots no download | free online bingo games | free money no deposit casinos | free slot machine | texas hold em free | best usa casino online | blackjack software | texas holdem free online
72.36.192.* 于 2007-06-21 07:52:47发表:
Thank you!
best poker sites | no deposit casino | video slots free | video slots | casino online download | poker games | free online poker game | free casino | poker game online | free online poker games
72.36.192.* 于 2007-06-21 07:52:35发表:
Good design!
hold em poker | poker texas holdem | no deposit casino bonuses | online blackjack | play bingo | texas poker | free poker sites | free online casino games | free slot machine play | texas holdem poker
71.56.221.* 于 2007-06-21 06:56:56发表:
quik payday loan quik payday loan http://www.kbcyberteacher.com/Santa06/00000085.htm 7 card stud seven card stud http://www.freewebs.com/casino-89/card-stud-6.html free online keno free keno games http://www.freewebs.com/casino-24/keno-2.html faxless payday loan faxless payday loan http://www.mysharktank.com/discuss/_disc1/0000015b.htm roulette casino game free roulette http://www.freewebs.com/casino-13/roulette-3.html
0.0.0.* 于 2007-06-21 06:54:57发表:
blogspot.com loan payday site blogspot.com loan payday site http://www.weddingwebsonline.com/goodman/guestbook/_disc17/00000206.htm play free slots http://www.freewebs.com/casino-13/slots-3.html play free slots payday cash loan payday cash loan http://www.yachtxperts.com/_bocam/0000097c.htm http://www.creativewebs2.com/_disc1/0000009c.htm payday loan store payday loan store 7 card stud http://www.freewebs.com/casino-89/card-stud-7.html seven card stud
71.56.221.* 于 2007-06-21 06:52:10发表:
http://www.freewebs.com/casino-44/casino-1.html vegas casino casino bonus http://www.freewebs.com/casino-66/keno-1.html play keno online free online keno payday loan debt http://members.tripod.com/branhamhighforum/_disc13/00000416.htm payday loan debt http://www.freewebs.com/casino-78/blackjack-6.html jack black jack black http://www.freewebs.com/casino-78/baccarat-1.html free baccarat baccarat game
85.214.25.* 于 2007-06-21 06:50:37发表:
free keno http://www.freewebs.com/casino-44/keno-5.html free keno payday loan debt payday loan debt http://cpb5332.k12.sd.us/_disc1/0000002f.htm seven card stud seven card stud http://www.freewebs.com/casino-44/card-stud-5.html http://www.freewebs.com/casino-78/roulette-2.html play free roulette play free roulette no credit check payday loan no credit check payday loan http://www.tryfontolides.com/_disc1/00001185.htm
24.164.135.* 于 2007-06-21 06:44:49发表:
play craps play craps online free http://www.freewebs.com/casino-78/craps-1.html instant payday loan http://www.globalduk.com/_disc1/00000264.htm instant payday loan free slots machine game casino slots http://www.freewebs.com/casino-44/slots-1.html http://www.freewebs.com/casino-97/roulette-3.html free roulette game free roulette http://www.theashlandsaints.com/Saints/00000059.htm easy payday loan easy payday loan
68.8.37.* 于 2007-06-21 06:31:35发表:
http://www.houselist.com/_forum4/000000b3.htm payday loan on line payday loan on line roulette gambling roulette gambling http://www.freewebs.com/casino-53/roulette-3.html seven card stud seven card stud http://www.freewebs.com/casino-78/card-stud-1.html free slots machine http://www.freewebs.com/casino-76/slots-7.html play slots payday loan canada payday loan canada http://www.sflcoc.com/_sflgb/000016e6.htm
88.39.112.* 于 2007-06-21 06:19:46发表:
ameriloan payday loan ameriloan payday loan http://www.dswa.org.uk/dswatalk/walling/00000963.htm online casino game http://www.freewebs.com/casino-24/casino-6.html online casino game play roulette online http://www.freewebs.com/casino-97/roulette-7.html roulette gambling cash advance paydayloans cash advance paydayloans http://www.rememberingheroes.org/_disc2/00001204.htm quik payday loan quik payday loan http://kreacom.com/_scd1/000000b3.htm
0.0.0.* 于 2007-06-21 06:07:11发表:
payday loan personal http://www.usechemicalssafely.com/_disc1/000000b3.htm payday loan personal how to play craps casino craps http://www.freewebs.com/casino-76/craps-3.html baccarat game free online baccarat http://www.freewebs.com/casino-13/baccarat-6.html http://www.freewebs.com/casino-24/slots-6.html online casino slots casino slots casino baccarat free baccarat http://www.freewebs.com/casino-68/baccarat-6.html
220.135.8.* 于 2007-06-21 05:41:48发表:
7 card stud http://www.freewebs.com/casino-66/card-stud-4.html seven card stud http://www.freewebs.com/casino-53/casino-6.html vegas casino online casino gambling http://www.freewebs.com/casino-24/casino-7.html casino games casino games http://appledelights.com/Old/_disc4/000018e9.htm payday loan canada payday loan canada http://www.cskennedy.com/bhsclassof61/_BHSdisc1/00000099.htm cheap payday loan cheap payday loan
207.158.20.* 于 2007-06-21 05:40:45发表:
7 card stud http://www.freewebs.com/casino-66/card-stud-4.html seven card stud http://www.freewebs.com/casino-53/casino-6.html vegas casino online casino gambling http://www.freewebs.com/casino-24/casino-7.html casino games casino games http://appledelights.com/Old/_disc4/000018e9.htm payday loan canada payday loan canada http://www.cskennedy.com/bhsclassof61/_BHSdisc1/00000099.htm cheap payday loan cheap payday loan
0.0.0.* 于 2007-06-21 05:39:24发表:
online keno keno online http://www.freewebs.com/casino-31/keno-3.html blogspot.com loan payday site blogspot.com loan payday site http://www.vikingnewz.org/web%20discussion/001/000000ad.htm online casino slots http://www.freewebs.com/casino-97/slots-3.html free casino slots payday loan debt payday loan debt http://www.bong-hit.com/_BongBuzz/00000dc2.htm payday cash loan http://www.agap-trento.org/_disc19/00001a45.htm payday cash loan
0.0.0.* 于 2007-06-21 05:38:34发表:
free baccarat http://www.freewebs.com/casino-53/baccarat-5.html free baccarat http://www.freewebs.com/casino-82/keno-5.html keno casino play keno online military payday loan military payday loan http://www.superslamcountdown.com/_Hunting_Alaska/0000004c.htm http://www.freewebs.com/casino-66/keno-4.html free keno free online keno payday cash advance payday cash advance http://www.agap-trento.org/_disc19/00001a44.htm
0.0.0.* 于 2007-06-21 05:27:05发表:
7 card stud seven card stud http://www.freewebs.com/casino-97/card-stud-6.html free casino casino gambling http://www.freewebs.com/casino-97/casino-2.html bad debt loan payday http://www.execsolutions.com/_disc4/000021e6.htm bad debt loan payday bad debt loan payday http://www.mamm-mariag.it/_disc12/000000fd.htm bad debt loan payday http://mycropthorne.co.uk/Forum/ParishPlan/0000005e.htm no fax payday loan no fax payday loan
201.248.42.* 于 2007-06-21 05:15:24发表:
119a63b0d7fe94b663f74a8f4afe58c9 http://6.ovetzi.org/uworld/index.html http://normativa-circolazione-giorno-festivi-autocarro.wdrksm.org/ http://azienda-di-soggiorno-a-milano.cmuvxp.org/ http://si-spogli-tolga-anca-reggiseno.rfnfwr.org/ http://mio-padre-tiranno-e-padrona.rfnfwr.org/ http://video-bollenti-spirito-caldi-arrapanti.kzsfzp.org/ http://lara-lazara-de-morais-souza.rfnfwr.org/ http://aereo-eletrico-modello-ed-elicottero.rfnfwr.org/ http://calcio-giovanile-coppa-lazio-2006-2007.rfnfwr.org/ http://suoneria-tre-metri-sopra-il-cielo.wdrksm.org/ 3281355dcdf7961a81348339c85b8f61
24.4.241.* 于 2007-06-20 14:19:32发表:
internet roulette roulette casino game http://www.freewebs.com/casino-45/roulette-6.html blogspot.com loan payday site blogspot.com loan payday site http://www.bhmvending.com/BVC_Forum/_forum/0000020b.htm online blackjack game java blackjack http://www.freewebs.com/casino-68/blackjack-2.html http://www.freewebs.com/casino-97/card-stud-5.html 7 card stud 7 card stud seven card stud http://www.freewebs.com/casino-68/card-stud-4.html seven card stud
67.188.204.* 于 2007-06-20 10:43:51发表:
http://www.freewebs.com/casino-13/baccarat-6.html online baccarat free online baccarat free baccarat casino baccarat http://www.freewebs.com/casino-68/baccarat-6.html casino slots casino slots http://www.freewebs.com/casino-24/slots-6.html http://www.usechemicalssafely.com/_disc1/000000b3.htm payday loan personal payday loan personal how to play craps how to play craps http://www.freewebs.com/casino-76/craps-3.html
0.0.0.* 于 2007-06-20 10:27:13发表:
7 card stud seven card stud http://www.freewebs.com/casino-76/card-stud-1.html http://www.elfrank.com/Blog/_disc1/00000c23.htm fast cash payday loan fast cash payday loan http://www.aunttee.com/Entries/0000003e.htm faxless payday loan faxless payday loan cash til payday loan cash til payday loan http://www.kentpullen.com/_disc1KentPullen/000001f7.htm online keno free online keno http://www.freewebs.com/casino-82/keno-6.html
210.205.32.* 于 2007-06-20 09:20:47发表:
http://www.freewebs.com/casino-78/craps-1.html play craps online free play craps online free http://www.freewebs.com/casino-97/roulette-3.html internet roulette roulette gambling http://www.globalduk.com/_disc1/00000264.htm instant payday loan instant payday loan easy payday loan easy payday loan http://www.theashlandsaints.com/Saints/00000059.htm sim slots casino slots http://www.freewebs.com/casino-44/slots-1.html
72.36.192.* 于 2007-06-20 07:57:32发表:
Good design!
free 24 ctu ringtone | free cellular south ringtones | free sprint pcs ringtones | free mp3 ringtone download | nokia ringtone | lg free ringtones | polyphonic ringtones | cricket ringtones | ringtones for tracfone | sms ringtones
72.36.192.* 于 2007-06-20 07:57:03发表:
Well done!
cellphone ringtones | composer ringtones | free ringtones lg | ringtone creator | free mp3 tones | mp3 to ringtone | ringtones verizon | free ringtones for t-mobile | 24 ctu ringtone | free ringtones for tmobile
72.36.192.* 于 2007-06-20 07:56:06发表:
Great work!
24 ring tones | free ringtones for alltel | ringtone nokia | ringtone motorola | free mp3 ringtones | free sprint ringtones | free nascar ringtones | mp3 ringtone | mp3 ringtone download | sprint ringtones
72.36.192.* 于 2007-06-20 07:55:44发表:
Good design!
verizon ringtones free | free boost ringtones | ringtones cingular | online ringtone converter | free cell phone ring tones | ringtone ctu | cellular one ringtones | ringtones free | nascar ringtones | free ringtones for nokia
72.36.192.* 于 2007-06-20 07:55:31发表:
Thank you!
samsung free ringtones | free bollywood ringtones | motorola ringtones | music ringtones | country ringtones | free wav ringtones | samsung ringtones | ctu ringtones | free ringtones downloads | free mp3 ringtone
67.39.202.* 于 2007-06-20 05:43:23发表:
money tree payday loan http://www.classicmullet.com/_disc2/0000248c.htm money tree payday loan loan till payday loan till payday http://www.strawberrydelights.com/_disc2/000003e4.htm savings account payday loan http://www.myblogproject.com/_disc1/00000075.htm savings account payday loan http://www.freewebs.com/casino-44/card-stud-4.html 7 card stud 7 card stud http://www.cskennedy.com/bhsclassof61/_BHSdisc1/0000009a.htm fast cash payday loan fast cash payday loan
0.0.0.* 于 2007-06-20 05:25:40发表:
free craps http://www.freewebs.com/casino-13/craps-2.html play craps http://www.peter-buswell.com/TheGreatConspiracy/00000c82.htm no teletrack payday loan no teletrack payday loan http://rlstaton.com/mymessageboard/_disc2/00001c44.htm fast cash payday loan fast cash payday loan http://www.classicmullet.com/_disc2/000024a7.htm savings account payday loan savings account payday loan http://www.mcap.ms/_mcap1/00000080.htm payday loan 1000 payday loan 1000
0.0.0.* 于 2007-06-20 05:23:41发表:
payday loan store payday loan store http://www.marysvilleteachers.org/forum/_MUTAdiscussion/00000689.htm loan til payday loan til payday http://www.impexo.se/_disc2/00000d02.htm http://www.aterhamtning.se/_disc9/00006f4e.htm instant faxless payday loan instant faxless payday loan http://www.hc.idv.tw/talkweb/_disc1/00000009.htm sonic payday loan sonic payday loan 7 card stud http://www.freewebs.com/casino-13/card-stud-7.html 7 card stud
12.217.120.* 于 2007-06-20 05:23:31发表:
free casino slots play free slots http://www.freewebs.com/casino-13/slots-3.html payday cash loan payday cash loan http://www.yachtxperts.com/_bocam/0000097c.htm seven card stud 7 card stud http://www.freewebs.com/casino-89/card-stud-7.html blogspot.com loan payday site blogspot.com loan payday site http://www.weddingwebsonline.com/goodman/guestbook/_disc17/00000206.htm payday loan store payday loan store http://www.creativewebs2.com/_disc1/0000009c.htm
0.0.0.* 于 2007-06-20 05:14:05发表:
cash til payday loan cash til payday loan http://www.cocoanutheads.com/_discussion-group/0000009b.htm cheap payday loan cheap payday loan http://www.theinboxcafe.com/_disc1/000000a1.htm free online baccarat http://www.freewebs.com/casino-76/baccarat-3.html play baccarat free keno http://www.freewebs.com/casino-44/keno-6.html keno online payday cash advance payday cash advance http://www.ragazzinet.it/Forum/Animali/_disc1/00000195.htm
0.0.0.* 于 2007-06-20 05:12:52发表:
http://www.vanuatu.usp.ac.fj/journo/_journo/00002d74.htm quik payday loan quik payday loan quick payday loan quick payday loan http://www.sticknrudder.net/myweb5/TW/00000796.htm 7 card stud http://www.freewebs.com/casino-44/card-stud-1.html 7 card stud no fax payday loan no fax payday loan http://www.complaign.com/_disc2/00000ed8.htm casino craps http://www.freewebs.com/casino-76/craps-1.html play craps online free
0.0.0.* 于 2007-06-20 05:11:10发表:
casino bonus free casino games http://www.freewebs.com/casino-31/casino-3.html blackjack odds play free blackjack http://www.freewebs.com/casino-87/blackjack-5.html roulette gambling http://www.freewebs.com/casino-44/roulette-7.html online roulette gambling casino craps http://www.freewebs.com/casino-13/craps-5.html how to play craps no credit check payday loan no credit check payday loan http://statewide.vir.org/k12discuss/_disc1/00005350.htm
0.0.0.* 于 2007-06-20 05:06:59发表:
7 card stud http://www.freewebs.com/casino-76/card-stud-1.html seven card stud fast cash payday loan http://www.elfrank.com/Blog/_disc1/00000c23.htm fast cash payday loan internet keno video keno http://www.freewebs.com/casino-82/keno-6.html faxless payday loan faxless payday loan http://www.aunttee.com/Entries/0000003e.htm http://www.kentpullen.com/_disc1KentPullen/000001f7.htm cash til payday loan cash til payday loan
0.0.0.* 于 2007-06-20 05:01:32发表:
online casino gambling http://www.freewebs.com/casino-53/casino-6.html best online casino gambling http://www.cskennedy.com/bhsclassof61/_BHSdisc1/00000099.htm cheap payday loan cheap payday loan http://www.freewebs.com/casino-66/card-stud-4.html 7 card stud 7 card stud payday loan canada http://appledelights.com/Old/_disc4/000018e9.htm payday loan canada free casino http://www.freewebs.com/casino-24/casino-7.html online casino
195.222.112.* 于 2007-06-20 05:00:08发表:
las vegas casino http://www.freewebs.com/casino-89/casino-4.html best online casino blogspot.com loan payday site blogspot.com loan payday site http://nc-code.com/_disc2/000007bb.htm http://www.freewebs.com/casino-68/card-stud-6.html 7 card stud 7 card stud http://www.romstampa.it/_disc1/00000180.htm payday loan debt payday loan debt quick payday loan http://www.elfrank.com/Blog/_disc1/00000c25.htm quick payday loan
82.79.46.* 于 2007-06-20 04:57:58发表:
blogspot.com fax loan no payday site blogspot.com fax loan no payday site http://www.blackhillsptcruisers.com/DiscussionWeb/_WDWGNext/00000232.htm http://www.freewebs.com/casino-78/blackjack-5.html online blackjack game free blackjack payday advance loan http://www.trufant.com/_disc1/000024ac.htm payday advance loan payday loan personal payday loan personal http://www.business-bytes.com/forum/_disc2/00002636.htm easy payday loan easy payday loan http://www.nlcgwh.com/_disc3/000008d1.htm
24.167.174.* 于 2007-06-20 04:45:45发表:
http://www.identityunit.com/_disc1/00000057.htm instant payday loan instant payday loan blackjack gambling blackjack online http://www.freewebs.com/casino-76/blackjack-7.html casino on net casino poker http://www.freewebs.com/casino-24/casino-4.html http://www.sandycreekconservancy.com/SCIForum/000000a4.htm savings account payday loan savings account payday loan online blackjack game online blackjack game http://www.freewebs.com/casino-31/blackjack-2.html
65.25.38.* 于 2007-06-20 04:38:01发表:
http://www.freewebs.com/casino-76/roulette-2.html free online roulette free online roulette baccarat game free online baccarat http://www.freewebs.com/casino-45/baccarat-1.html fax payday loan fax payday loan http://www.hortari.com/disc1/000001fa.htm http://www.freewebs.com/casino-87/casino-3.html casino game free casino faxless payday loan faxless payday loan http://www.domanisocialista.it/mioweb15/_disc19/000009f8.htm