初学者如何学习分析函数-红联Linux系统门户

经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。

常用的分析函数如下所列:

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-25 07:41:59发表:

http://www.dconline.biz/lforum4/_disc42/0000052d.htm same day payday loan same day payday loan free keno http://www.freewebs.com/casino-44/keno-7.html keno online sonic payday loan sonic payday loan http://www.tecnoago.it/Forum/_messaggi/000005d8.htm payday loan store http://www.homeroom.net/_board/00000741.htm payday loan store faxless payday loan http://www.froguild.org/discussion/_disc1/000004fd.htm faxless payday loan

71.199.148.* 于 2007-06-25 06:20:58发表:

Send party poker com

0.0.0.* 于 2007-06-25 06:14:23发表:

After that pacific poker download

0.0.0.* 于 2007-06-25 05:36:39发表:

play free blackjack http://www.freewebs.com/casino-45/blackjack-1.html online blackjack game bad credit payday loan bad credit payday loan http://www.thetalkingfrog.com/_disc1/00000289.htm savings account payday loan http://www.myhedo.com/General/0000006e.htm savings account payday loan free keno keno online http://www.freewebs.com/casino-31/keno-1.html craps online http://www.freewebs.com/casino-45/craps-4.html casino craps

0.0.0.* 于 2007-06-25 05:28:43发表:

Rate online poker rooms

0.0.0.* 于 2007-06-25 04:26:38发表:

http://applesoranges.us/videos/_disc22/000000da.htm no faxing payday loan no faxing payday loan play slots play slots http://www.freewebs.com/casino-44/slots-7.html ameriloan payday loan ameriloan payday loan http://www.kore.negros.ph/_forum/00000c9a.htm free craps game http://www.freewebs.com/casino-78/craps-4.html free craps game payday loan personal http://www.painareas.com/_disc1/0000011a.htm payday loan personal

68.192.215.* 于 2007-06-25 03:38:58发表:

Although party poker bonus

0.0.0.* 于 2007-06-25 03:33:05发表:

As the texas hold em poker online

122.197.98.* 于 2007-06-25 03:25:52发表:

In other words online free poker

68.207.99.* 于 2007-06-25 03:25:16发表:

Consolidate party poker bonus

24.14.248.* 于 2007-06-25 03:04:04发表:

You free texas hold em

204.48.128.* 于 2007-06-25 03:03:44发表:

Let's start with free party poker

0.0.0.* 于 2007-06-25 03:03:25发表:

0.0.0.* 于 2007-06-25 02:59:58发表:

Come free video poker games

200.84.133.* 于 2007-06-24 14:26:38发表:

f0b3e24c94aa74398b5fd149a75f7f32 http://fotocalendario2007tronistauomodonna.fmyuaf.org/foto-e-video-di-piedi/ http://biglietto-d-augurio-simpatico-divertente.iolfyk.org/ http://forum-integratore-top-diet-vital-factors.cjgbgx.org/ http://cinemateatrotedescoanno80.savnjk.org/studio-medico-prof-massimo-volpe/ http://durante-ciclo-si-puo-rimanere-incinta.cjgbgx.org/ http://discorsobenvenutoalnuovoparroco.shopio.org/decreto-ingiuntivo-revoca-ab-origine-capitalizzazione/ http://universosensosoltantoqualcunocondividereemozione.fmyuaf.org/ambulatorio-medico-contratto-locazione-soggetto-iva/ http://softwaresharewareconvertirefilemovmpeg.savnjk.org/vendita-on-line-statua-legno/ http://impresasoafvg.savnjk.org/santa-maria-popolo-chiesa-roma/ http://impresasoafvg.savnjk.org/calendario-esame-scienza-formazione-messina/ 452262cf741011e1ab8f1c4bc30a15a9

72.36.192.* 于 2007-06-24 07:57:51发表:

72.36.192.* 于 2007-06-24 07:57:22发表:

72.36.192.* 于 2007-06-24 07:56:19发表:

72.36.192.* 于 2007-06-24 07:55:58发表:

72.36.192.* 于 2007-06-24 07:55:47发表:

66.169.105.* 于 2007-06-23 13:27:15发表:

instant payday loan http://www.savannahslim.com/talkingSpirits/_disc1/0000024a.htm instant payday loan play roulette online http://www.freewebs.com/casino-89/roulette-1.html casino roulette how to play craps free online craps http://www.freewebs.com/casino-78/craps-2.html payday loan personal payday loan personal http://www.trufant.com/_disc1/000024ab.htm http://www.freewebs.com/casino-31/craps-2.html free online craps free online craps

70.82.209.* 于 2007-06-23 13:09:50发表:

73c2bb4d46a0d313305662166cf7efd3 http://bus-navetta-padova-venezia-capodanno.wyhedi.org/ http://trasferiremusicainipod.inpusz.org/g-s-d-cornigliano-genova/ http://stadiositesportmsnit.ihbepf.org/offerta-viaggi-per-gran-canaria/ http://tutto-ultima-puntata-c-posta-te.bxertr.org/ http://caldaia-murali-gas-metano-esterno.xprlxl.org/ http://sindacato-cgl-roma-trasporto-aereo.vjsvzo.org/ http://art-24-festivita-ente-locale.wyhedi.org/ http://cassazionedivisioneperditaacquacondominio.knqtun.org/cuore-tenebra-conrad-scheda-libro/ http://hotel-mas-alto-en-barcellona.xprlxl.org/ http://scuola-calcio-geos-sport-club.mjhbun.org/ 9552dfe41baaa9f17aeb9f3e17cab334

68.54.160.* 于 2007-06-23 10:24:17发表:

http://sg3018.k12.sd.us/_disc1/0000003e.htm payday loan on line payday loan on line payday advance loan payday advance loan http://mj3024.k12.sd.us/_disc1/00000041.htm ez payday loan ez payday loan http://timeforaction.org/_disc2/00000ed8.htm sim slots http://www.freewebs.com/casino-44/slots-6.html play free slots machine http://www.tazenda.net/discussion/_disc1/00000eaa.htm loan til payday loan til payday

0.0.0.* 于 2007-06-23 09:44:25发表:

http://www.freewebs.com/casino-44/roulette-5.html free roulette game internet roulette http://www.iaap-satellite.org/_disc1/00001120.htm same day payday loan same day payday loan http://ss3054.k12.sd.us/_disc1/00000040.htm same day payday loan same day payday loan military payday loan military payday loan http://www.globalduk.com/_disc1/00000265.htm http://huntersvalley.net/_bulletinboard/00000437.htm same day payday loan same day payday loan

222.124.197.* 于 2007-06-23 08:09:38发表:

quick payday loan http://www.leshartman.com/Band/Forum2/_disc8/000005da.htm quick payday loan cash advance payday loan cash advance payday loan http://www.post3legion.com/_disc1/0000008b.htm http://www.freewebs.com/casino-66/roulette-1.html play free roulette play free roulette fax payday loan fax payday loan http://www.agap-trento.org/_disc19/00001a46.htm fast payday loan http://www.rajmaai.com/_rajmaai/0000089b.htm fast payday loan

72.36.192.* 于 2007-06-23 07:56:14发表:

72.36.192.* 于 2007-06-23 07:55:41发表:

72.36.192.* 于 2007-06-23 07:54:44发表:

72.36.192.* 于 2007-06-23 07:54:28发表:

72.36.192.* 于 2007-06-23 07:54:16发表:

222.124.197.* 于 2007-06-23 07:32:11发表:

payday loan 1000 payday loan 1000 http://www.northpulaski.com/mysite2/_disc2/00000279.htm online craps play craps http://www.freewebs.com/casino-45/craps-5.html easy payday loan http://www.kawiswaradharma.org/forum/000000b9.htm easy payday loan http://www.freewebs.com/casino-87/casino-2.html vegas casino casino game sonic payday loan http://www.barbaraboudion.com/_LT71DISCUSSION/00000071.htm sonic payday loan

71.56.221.* 于 2007-06-23 06:04:21发表:

online roulette game free roulette http://www.freewebs.com/casino-13/roulette-7.html video keno http://www.freewebs.com/casino-41/keno-1.html free online keno quick payday loan quick payday loan http://www.southwark.anglican.org/encounter/_disc1/00003bc6.htm online casino slots http://www.freewebs.com/casino-66/slots-1.html slots game http://www.freewebs.com/casino-76/blackjack-5.html blackjack game play blackjack online

68.178.39.* 于 2007-06-23 06:00:07发表:

easy payday loan easy payday loan http://www.mederrorreport.com/_disc1/00000481.htm free baccarat free online baccarat http://www.freewebs.com/casino-87/baccarat-2.html http://www.freewebs.com/casino-45/baccarat-3.html baccarat game casino baccarat fast cash payday loan fast cash payday loan http://thebluesband.com/webforum/_disc23/00003b65.htm online casino blackjack online casino blackjack http://www.freewebs.com/casino-68/blackjack-1.html

0.0.0.* 于 2007-06-23 04:20:15发表:

payday loan online payday loan online http://www.powerdreamteam.com/members/_GEL/00000095.htm http://www.veevoo.com/_bitching_disc1/0000001c.htm payday loan online payday loan online http://www.freewebs.com/casino-76/card-stud-4.html 7 card stud seven card stud bad debt loan payday bad debt loan payday http://www.laspalmascondo.net/_owners/0000009b.htm 7 card stud seven card stud http://www.freewebs.com/casino-24/card-stud-5.html

0.0.0.* 于 2007-06-23 04:06:35发表:

money tree payday loan money tree payday loan http://www.polishnetwork.com/polishnetwork/_disc1/000034b7.htm http://www.mby2.com/_cusudi/0000004c.htm cash advance paydayloans cash advance paydayloans free online slots slots game http://www.freewebs.com/casino-44/slots-2.html http://www.freewebs.com/casino-45/baccarat-5.html online baccarat baccarat online http://www.freewebs.com/casino-13/blackjack-1.html free online blackjack free online blackjack

190.16.101.* 于 2007-06-23 04:04:05发表:

http://www.freewebs.com/casino-53/blackjack-4.html free blackjack play blackjack online loan till payday http://www.usechemicalssafely.com/_disc1/000000b2.htm loan till payday instant payday loan instant payday loan http://www.webservicesplus.com/_disc14/00002cbe.htm bad debt loan payday bad debt loan payday http://www.polioakpavilion.org/association/_talk_1/0000006e.htm payday loan 1000 payday loan 1000 http://www.aromaticsage.com/_disc10/00000782.htm

201.53.100.* 于 2007-06-23 03:45:04发表:

no teletrack payday loan no teletrack payday loan http://members.tripod.com/branhamhighforum/_disc13/00000415.htm easy payday loan easy payday loan http://www.packroute.com/forum/_disc6/000008ec.htm no credit check payday loan http://www.pfm.com.hk/_disc4/00002c50.htm no credit check payday loan internet blackjack http://www.freewebs.com/casino-66/blackjack-5.html blackjack gambling free keno http://www.freewebs.com/casino-87/keno-6.html keno online

0.0.0.* 于 2007-06-23 02:35:44发表:

loan til payday loan til payday http://www.allfearless.com/timinator/longmont/_disc1/00001482.htm http://www.freewebs.com/casino-68/slots-7.html progressive slots sim slots free online keno free keno http://www.freewebs.com/casino-66/keno-7.html http://www.brahman.co.za/Discussion/_disc2/00002392.htm military payday loan military payday loan roulette tip online roulette gambling http://www.freewebs.com/casino-13/roulette-2.html

0.0.0.* 于 2007-06-23 02:35:37发表:

online roulette free roulette http://www.freewebs.com/casino-76/roulette-5.html payday loan store payday loan store http://www.mby2.com/_cusudi/0000004b.htm payday loan payday loan http://abram4obama.com/Obama/00000002.htm baccarat online baccarat online http://www.freewebs.com/casino-87/baccarat-3.html online slots online slots machine http://www.freewebs.com/casino-87/slots-7.html

24.218.203.* 于 2007-06-23 02:34:49发表:

casino gaming http://www.freewebs.com/casino-31/casino-6.html casino on net no faxing payday loan no faxing payday loan http://www.essex.ac.uk/afm/ma-discuss/_afm-ma-discuss/000009ff.htm free baccarat play baccarat http://www.freewebs.com/casino-89/baccarat-5.html fast cash payday loan fast cash payday loan http://www.peter-buswell.com/TheGreatConspiracy/00000c81.htm http://www.freewebs.com/casino-31/slots-2.html free slots machine online slots machine

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐