经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-06-23 02:32:58发表:
free online baccarat baccarat game http://www.freewebs.com/casino-89/baccarat-1.html http://www.cancerwithgod.com/_cancer/000000dc.htm quik payday loan quik payday loan http://www.freewebs.com/casino-24/baccarat-1.html baccarat online free online baccarat low fee payday loan http://www.lo-ung.com/_disc6/00000539.htm low fee payday loan cash advance payday loan cash advance payday loan http://www.ssc.com.kw/DB/_disc1/00003d5c.htm
0.0.0.* 于 2007-06-23 02:30:18发表:
7 card stud 7 card stud http://www.freewebs.com/casino-66/card-stud-6.html payday advance loan http://www.nldguide.com/_kbas/00000140.htm payday advance loan low fee payday loan low fee payday loan http://www.hurricanerunners.net/_disc1/00000097.htm cheap payday loan cheap payday loan http://www.bioyma.com/_truehearts/_disc1/000000b4.htm payday advance loan payday advance loan http://www.westernstars.org/_WesternStars/00000070.htm
0.0.0.* 于 2007-06-23 02:24:13发表:
free casino games free casino games http://www.freewebs.com/casino-24/casino-3.html http://tmtyl.com/stories/_forum/00003e89.htm loan till payday loan till payday payday loan online payday loan online http://www.kore.negros.ph/_forum/00000c99.htm play keno online internet keno http://www.freewebs.com/casino-45/keno-2.html http://warmsector.com/_storm_forum/0000009b.htm instant faxless payday loan instant faxless payday loan
67.82.209.* 于 2007-06-23 02:23:39发表:
cash advance payday loan http://www.webservicesplus.com/_disc14/00002cbb.htm cash advance payday loan quick payday loan quick payday loan http://www.boulbeaconsfield.com/_disc1/000000a0.htm savings account payday loan savings account payday loan http://www.sonnymcleans.com/_disc17/0000670a.htm fax payday loan fax payday loan http://www.domeoverride.com/_disc1/00001df1.htm http://www.freewebs.com/casino-44/casino-3.html vegas casino vegas casino
0.0.0.* 于 2007-06-23 02:20:41发表:
best online casino online casino game http://www.freewebs.com/casino-68/casino-2.html sonic payday loan sonic payday loan http://www.niles-hs.k12.il.us/heaing/_51-75/00003ecf.htm free online baccarat http://www.freewebs.com/casino-31/baccarat-7.html baccarat online http://www.hypocrats.org/_discussion/00000144.htm payday loan on line payday loan on line seven card stud http://www.freewebs.com/casino-76/card-stud-6.html seven card stud
0.0.0.* 于 2007-06-23 02:10:40发表:
cash advance paydayloans cash advance paydayloans http://cb3057.k12.sd.us/_disc1/0000002a.htm http://www.freewebs.com/casino-66/roulette-3.html play roulette play roulette payday loan http://www.labarbabietola.it/forum/forum/000009f7.htm payday loan free blackjack game free online blackjack game http://www.freewebs.com/casino-31/blackjack-6.html cash advance payday loan cash advance payday loan http://www.iveco-kundendienst.de/diskussion/stralis/_disc12/000009a0.htm
24.107.188.* 于 2007-06-23 02:07:43发表:
sonic payday loan http://www.wildlocals.com/_disc1/00001257.htm sonic payday loan free slots no download http://www.freewebs.com/casino-31/slots-7.html play free slots no teletrack payday loan no teletrack payday loan http://www.trickip.com/_TrickIP/000037fa.htm http://www.freewebs.com/casino-53/slots-4.html slots machine game slots machine game quick payday loan quick payday loan http://www.calvarymostudents.com/_hangarchats/000003c2.htm
71.203.162.* 于 2007-06-23 01:59:21发表:
payday loan http://www.alessiamore.it/file%20nascosti/_disc10/00000257.htm payday loan vegas casino http://www.freewebs.com/casino-76/casino-1.html online casino gambling free roulette free roulette http://www.freewebs.com/casino-53/roulette-2.html http://www.ssc.com.kw/DB/_disc1/00003d5b.htm quik payday loan quik payday loan cheap payday loan cheap payday loan http://www.kawiswaradharma.org/forum/000000ba.htm
82.99.201.* 于 2007-06-23 01:28:52发表:
ameriloan payday loan ameriloan payday loan http://clubmobil.at/_gaeste/00001a1e.htm http://www.freewebs.com/casino-13/casino-5.html las vegas casino vegas casino payday loan payday loan http://www.haircountry.com/_forum/00001fbb.htm instant faxless payday loan http://www.arbor-inc.biz/_disc9/000000ed.htm instant faxless payday loan fast cash payday loan fast cash payday loan http://www.kawiswaradharma.org/forum/000000b8.htm
83.220.194.* 于 2007-06-23 01:28:46发表:
ameriloan payday loan ameriloan payday loan http://clubmobil.at/_gaeste/00001a1e.htm http://www.freewebs.com/casino-13/casino-5.html las vegas casino vegas casino payday loan payday loan http://www.haircountry.com/_forum/00001fbb.htm instant faxless payday loan http://www.arbor-inc.biz/_disc9/000000ed.htm instant faxless payday loan fast cash payday loan fast cash payday loan http://www.kawiswaradharma.org/forum/000000b8.htm
0.0.0.* 于 2007-06-23 01:16:15发表:
http://www.johnburrowsproject.com/_kbas/0000004c.htm fax payday loan fax payday loan http://www.freewebs.com/casino-24/slots-5.html online slots play slots online roulette game online roulette http://www.freewebs.com/casino-53/roulette-4.html online blackjack blackjack game http://www.freewebs.com/casino-44/blackjack-7.html sonic payday loan http://www.mederrorreport.com/_disc1/00000482.htm sonic payday loan
0.0.0.* 于 2007-06-23 01:15:26发表:
ameriloan payday loan ameriloan payday loan http://www.gotobaker.com/_job1disc/0000009c.htm http://www.froguild.org/discussion/_disc1/000004fe.htm cash til payday loan cash til payday loan payday loan store payday loan store http://www.trps.ptc.edu.tw/myweb2/_disc4/0000161d.htm http://www.stmichaelsingles.com/_openforum/00001188.htm payday loan on line payday loan on line cheap payday loan cheap payday loan http://24-7christianministries.com/_24-7Ministriesdisc1/00000064.htm
204.48.128.* 于 2007-06-23 00:59:31发表:
no teletrack payday loan no teletrack payday loan http://www.broncohut.com/_Trucks/00004d71.htm payday loan personal payday loan personal http://www.luxury-cruises-forum.com/_LuxuryCruises/0000061c.htm savings account payday loan savings account payday loan http://www.solvepc.com/forum/_disc/0000019e.htm 7 card stud seven card stud http://www.freewebs.com/casino-31/card-stud-7.html http://www.freewebs.com/casino-89/casino-1.html casino gaming casino gaming
0.0.0.* 于 2007-06-23 00:40:33发表:
payday advance loan payday advance loan http://www.alicevroberts.com/Discussion1/0000032f.htm payday cash advance payday cash advance http://www.hypocrats.org/_discussion/00000146.htm payday loan canada payday loan canada http://www.allfearless.com/timinator/longmont/_disc1/00001484.htm fax payday loan http://www.dswa.org.uk/dswatalk/walling/00000965.htm fax payday loan instant payday loan instant payday loan http://www.dylanryanmay.com/_disc1/00000051.htm
202.28.27.* 于 2007-06-23 00:31:56发表:
payday cash advance http://www.bioyma.com/_truehearts/_disc1/000000b2.htm payday cash advance fax payday loan fax payday loan http://www.goodfelloweb.com/cottage/_disc1/00000c37.htm online roulette game online roulette game http://www.freewebs.com/casino-45/roulette-1.html casino games http://www.freewebs.com/casino-66/casino-5.html casino slots http://tuvc.com/tech/_disc11/00000042.htm quik payday loan quik payday loan
68.81.7.* 于 2007-06-23 00:02:14发表:
play blackjack online free http://www.freewebs.com/casino-97/blackjack-7.html online casino blackjack http://www.mcap.ms/_mcap1/0000007e.htm instant payday loan instant payday loan http://kreacom.com/_scd1/000000b1.htm payday cash advance payday cash advance instant faxless payday loan http://www.niles-hs.k12.il.us/heaing/_51-75/00003ece.htm instant faxless payday loan seven card stud seven card stud http://www.freewebs.com/casino-82/card-stud-3.html
0.0.0.* 于 2007-06-22 23:57:07发表:
blackjack odds casino blackjack http://www.freewebs.com/casino-97/blackjack-1.html payday loan 1000 payday loan 1000 http://www.whichsideofthefence.com/_disc7/00000079.htm payday loan store payday loan store http://www.rebbook.com/_disc1/000003fa.htm http://www.freewebs.com/casino-44/blackjack-3.html free blackjack online blackjack fax payday loan fax payday loan http://www.tourdepub.com/_smack/00001211.htm
0.0.0.* 于 2007-06-22 23:28:43发表:
7 card stud 7 card stud http://www.freewebs.com/casino-66/card-stud-7.html play baccarat online baccarat http://www.freewebs.com/casino-13/baccarat-1.html payday advance loan http://www.fairview66.com/Data2/00000053.htm payday advance loan payday loan on line payday loan on line http://tuvc.com/tech/_disc11/00000043.htm blogspot.com loan payday site http://nc-code.com/_disc2/000007bc.htm blogspot.com loan payday site
24.75.99.* 于 2007-06-22 23:27:13发表:
free slots progressive slots http://www.freewebs.com/casino-78/slots-4.html http://www.freewebs.com/casino-45/card-stud-4.html 7 card stud seven card stud free baccarat free baccarat http://www.freewebs.com/casino-24/baccarat-7.html money tree payday loan money tree payday loan http://www.thatreefguy.com/_board/00000f80.htm ameriloan payday loan ameriloan payday loan http://othbasketball.org/_disc1/00000097.htm
221.85.72.* 于 2007-06-22 23:18:37发表:
free online keno free online keno http://www.freewebs.com/casino-89/keno-5.html http://www.peru.no/Peru-Noruega/00001edc.htm ameriloan payday loan ameriloan payday loan internet keno keno casino http://www.freewebs.com/casino-82/keno-2.html low fee payday loan http://www.cours.polymtl.ca/tic/_disc1/00000033.htm low fee payday loan craps game http://www.freewebs.com/casino-89/craps-2.html craps game
70.238.66.* 于 2007-06-22 23:16:04发表:
video keno online keno http://www.freewebs.com/casino-89/keno-4.html cash til payday loan http://www.ruthiesarc.org/_disc2/00004d51.htm cash til payday loan internet blackjack free online blackjack http://www.freewebs.com/casino-76/blackjack-3.html instant faxless payday loan instant faxless payday loan http://www.mayfirstjobs.com/MayFirstJobs/00000049.htm faxless payday loan faxless payday loan http://warmsector.com/_storm_forum/0000009a.htm
201.17.235.* 于 2007-06-22 23:11:38发表:
http://www.ghetto-prophetz.com/_disc1/0000016e.htm blogspot.com loan payday site blogspot.com loan payday site internet keno http://www.freewebs.com/casino-97/keno-6.html online keno casino roulette play free roulette http://www.freewebs.com/casino-45/roulette-4.html quik payday loan quik payday loan http://www.citizensmatrix.com/_disc1/000000e8.htm http://www.thecompassionatefriends.org.au/_discOpen/00001415.htm payday loan personal payday loan personal
0.0.0.* 于 2007-06-22 22:34:56发表:
military payday loan military payday loan http://www.myblogproject.com/_disc1/00000074.htm free online baccarat baccarat game http://www.freewebs.com/casino-68/baccarat-1.html http://www.freewebs.com/casino-68/craps-3.html play craps craps game fax payday loan http://www.angelosandri.info/lforum/_disc39/00000467.htm fax payday loan bad debt loan payday http://www.dlef.co.uk/discform/_disc4/000004d5.htm bad debt loan payday
0.0.0.* 于 2007-06-22 11:35:05发表:
free online blackjack game internet blackjack http://www.freewebs.com/casino-66/blackjack-4.html http://www.vagleleiren.sandnes.no/odisk/_olopdisk/000003e5.htm sonic payday loan sonic payday loan play free roulette free online roulette http://www.freewebs.com/casino-66/roulette-2.html http://intellegentpursuits.com/_first/0000004a.htm online payday loan online payday loan no fax payday loan no fax payday loan http://suggeststuff.com/suggeststuff/00000050.htm
0.0.0.* 于 2007-06-22 11:34:13发表:
http://www.freewebs.com/casino-66/casino-4.html vegas casino free casino http://www.freewebs.com/casino-45/card-stud-1.html seven card stud seven card stud cash advance paydayloans cash advance paydayloans http://www.purperofamily.org/_disc1/00000037.htm http://www.fourvalves.com/chat/00000073.htm instant faxless payday loan instant faxless payday loan casino bonus casino bonus http://www.freewebs.com/casino-13/casino-2.html
200.112.172.* 于 2007-06-22 10:56:47发表:
e48b9271a6d57950c52b9a8c8e5af9ac http://significato-c-o-f-s.nakusq.org/ http://aiuto-donna-musulmane-non-vergine.ytwviq.org/ http://sfondocellularesamsungsgh510.owknpa.org/documento-programmatico-sicurezza-bozza-albergo/ http://8-circolo-didattico-pozzuoli-licola.ytwviq.org/ http://meccanismo-passaggio-attraverso-membrana-biologiche.nakusq.org/ http://hotel-a-roma-4-stelle.myniqy.org/ http://elencoclientefornitored2006.qurqnr.org/formazione-sopralluogo-insediamenti-produttivi-scarico-industriale/ http://portodarmausosportivo.fvgoov.org/gratis-tutto-slot-genio-lampada/ http://lanascitadiunbambino.fvgoov.org/chiesa-s-maria-d-capodarco-marche/ http://sitointeressecomunitariomontealbonuoro.owknpa.org/arredamento-and-negozio-and-savona/ 8d0a7cd2b17a8f039de7dab06d2ae220
222.76.214.* 于 2007-06-22 10:55:53发表:
http://www.freewebs.com/casino-78/slots-1.html online slots online slots baccarat online baccarat online http://www.freewebs.com/casino-89/baccarat-2.html http://www.peru.no/Peru-Noruega/00001edd.htm cheap payday loan cheap payday loan payday loan store payday loan store http://www.marysvilleteachers.org/forum/_MUTAdiscussion/0000068a.htm http://mycropthorne.co.uk/Forum/ParishPlan/0000005f.htm no teletrack payday loan no teletrack payday loan
222.76.214.* 于 2007-06-22 08:54:15发表:
payday loan 1000 payday loan 1000 http://appledelights.com/Old/_disc4/000018ea.htm rules of craps http://www.freewebs.com/casino-24/craps-4.html rules of craps no faxing payday loan no faxing payday loan http://cpb5332.k12.sd.us/_disc1/0000002d.htm payday loan online payday loan online http://www.isslr.org/MemberForum/_MemForum/00001729.htm http://kofc11020.org/_disc1/00000317.htm sonic payday loan sonic payday loan
72.40.34.* 于 2007-06-22 08:25:01发表:
online roulette gambling online roulette gambling http://www.freewebs.com/casino-78/roulette-5.html roulette tip play roulette http://www.freewebs.com/casino-89/roulette-7.html http://www.freewebs.com/casino-53/slots-5.html play slots free slots machine game http://www.ipaquebec.ca/_disc/00000b43.htm payday loan debt payday loan debt keno casino http://www.freewebs.com/casino-82/keno-1.html keno casino
201.65.169.* 于 2007-06-22 08:12:27发表:
http://fouinax.com/FEM_FORUM/000000d1.htm blogspot.com loan payday site blogspot.com loan payday site blackjack gambling http://www.freewebs.com/casino-53/blackjack-1.html play blackjack casino roulette http://www.freewebs.com/casino-68/roulette-3.html roulette game low fee payday loan http://www.whichsideofthefence.com/_disc7/0000007a.htm low fee payday loan http://www.coloradotbf.net/Discussion/0000011c.htm no faxing payday loan no faxing payday loan
72.36.192.* 于 2007-06-22 08:04:52发表:
Thank you!
download free poker | hold em poker | free slots no download | 3 card poker | poker free download | free slot games | black jack strip | free video slots | games download | online free roulette
72.36.192.* 于 2007-06-22 08:04:24发表:
Thank you!
online slot games | free no deposit casino | new no deposit casinos | video slot | on line gambling | gambling machines | free online bingo | casino on net | casino online download | blackjack games
88.39.112.* 于 2007-06-22 08:03:32发表:
cash advance paydayloans cash advance paydayloans http://www.cdedi.org/CDED/00000035.htm how to play craps play craps http://www.freewebs.com/casino-53/craps-4.html http://www.freewebs.com/casino-31/card-stud-6.html seven card stud 7 card stud play free slots free slots game http://www.freewebs.com/casino-89/slots-7.html sonic payday loan sonic payday loan http://www.haveyoursay.us/_disc1/00002f26.htm
72.36.192.* 于 2007-06-22 08:03:18发表:
Well done!
free slots games | caribbean stud poker | free no download slots | caribbean poker | free poker downloads | slot games | roulette download | free slots download | play blackjack | poker software
72.36.192.* 于 2007-06-22 08:02:59发表:
Nice site!
no deposit bingo | flash casinos | russian roulette game | internet poker | play texas holdem online | play texas holdem | joker poker | free online slots no downloads | texas holdem free | free poker sites
72.36.192.* 于 2007-06-22 08:02:47发表:
Nice site!
free online slots games | strip blackjack game | black jack | online slots free | texas hold em poker | casino slots | no deposit bonuses | strip blackjack games | poker bonus | free blackjack games
125.120.139.* 于 2007-06-22 07:34:49发表:
202.28.27.* 于 2007-06-22 07:06:16发表:
ez payday loan ez payday loan http://www.animalcarectrs.com/_disc1/00000e20.htm http://www.freewebs.com/casino-44/blackjack-2.html jack black blackjack gambling video keno http://www.freewebs.com/casino-68/keno-5.html keno casino http://www.freewebs.com/casino-45/craps-7.html play craps free craps http://www.strawberrydelights.com/_disc2/000003e2.htm payday loan debt payday loan debt
66.192.6.* 于 2007-06-22 07:05:50发表:
ez payday loan ez payday loan http://www.animalcarectrs.com/_disc1/00000e20.htm http://www.freewebs.com/casino-44/blackjack-2.html jack black blackjack gambling video keno http://www.freewebs.com/casino-68/keno-5.html keno casino http://www.freewebs.com/casino-45/craps-7.html play craps free craps http://www.strawberrydelights.com/_disc2/000003e2.htm payday loan debt payday loan debt
76.175.36.* 于 2007-06-22 07:04:23发表:
payday loan canada payday loan canada http://www.magyarorokseghete.hu/vita/_disc1/00000019.htm free online keno http://www.freewebs.com/casino-44/keno-4.html video keno seven card stud 7 card stud http://www.freewebs.com/casino-53/card-stud-1.html http://www.cmpatristate.com/myweb/discussions/00001469.htm payday cash advance payday cash advance payday cash loan payday cash loan http://www.connselmerstrike.com/_HArticles/00000042.htm