红联Linux门户
Linux帮助
当前位置: 红联Linux门户 > Linux数据库应用

初学者如何学习分析函数

发布时间:2006-11-05 00:48:45来源:红联作者:flycocoon
经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。

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

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
文章评论

共有 2615 条评论

  1. 87.120.228.* 于 2007-06-29 03:59:40发表:

    roulette table roulette table http://www.freewebs.com/casino-44/roulette-6.html payday loan personal payday loan personal http://www.chaoselites.com/Discussion/000001d8.htm roulette table http://www.freewebs.com/casino-45/roulette-5.html roulette online no credit check payday loan http://www.valleygroup.org/VG_disc1/00000091.htm no credit check payday loan money tree payday loan money tree payday loan http://www.vereinsring-liederbach.de/_disc1/0000000e.htm

  2. 85.25.140.* 于 2007-06-29 03:46:39发表:

    http://www.barbaraboudion.com/_LT71DISCUSSION/00000070.htm payday loan personal payday loan personal fast cash payday loan http://www.niles-hs.k12.il.us/heaing/_51-75/00003ed0.htm fast cash payday loan play slots http://www.freewebs.com/casino-45/slots-7.html casino slots baccarat game http://www.freewebs.com/casino-45/baccarat-4.html free online baccarat http://www.freewebs.com/casino-68/craps-2.html online casino craps online craps

  3. 76.101.129.* 于 2007-06-29 03:46:03发表:

    http://www.barbaraboudion.com/_LT71DISCUSSION/00000070.htm payday loan personal payday loan personal fast cash payday loan http://www.niles-hs.k12.il.us/heaing/_51-75/00003ed0.htm fast cash payday loan play slots http://www.freewebs.com/casino-45/slots-7.html casino slots baccarat game http://www.freewebs.com/casino-45/baccarat-4.html free online baccarat http://www.freewebs.com/casino-68/craps-2.html online casino craps online craps

  4. 207.61.242.* 于 2007-06-29 03:22:44发表:

    fast cash payday loan fast cash payday loan http://www.cdedi.org/CDED/00000036.htm http://www.cfpcf.org/_disc1/00000060.htm faxless payday loan faxless payday loan casino blackjack casino blackjack http://www.freewebs.com/casino-31/blackjack-5.html ez payday loan http://www.theashlandsaints.com/Saints/0000005a.htm ez payday loan payday loan personal http://www.gottagetgear.com/_disc1/00000127.htm payday loan personal

  5. 203.247.156.* 于 2007-06-29 02:11:06发表:

    http://www.freewebs.com/casino-78/keno-3.html play keno online internet keno http://www.boulbeaconsfield.com/_disc1/0000009f.htm payday loan canada payday loan canada internet keno free keno http://www.freewebs.com/casino-87/keno-4.html payday advance loan http://www.cfpcf.org/_disc1/0000005f.htm payday advance loan http://www.hcctustin.com/Prayer/DiscussionBoard/000000e4.htm cheap payday loan cheap payday loan

  6. 0.0.0.* 于 2007-06-29 01:46:00发表:

    http://www.impexo.se/_disc2/00000d01.htm savings account payday loan savings account payday loan casino slots casino slots http://www.freewebs.com/casino-87/casino-5.html online roulette poker http://www.freewebs.com/casino-13/roulette-6.html online roulette poker easy payday loan easy payday loan http://www.haveyoursay.us/_disc1/00002f24.htm no faxing payday loan no faxing payday loan http://www.dylanryanmay.com/_disc1/00000055.htm

  7. 201.54.164.* 于 2007-06-28 23:35:44发表:

    payday loan online http://www.dcsselect.eu/_disc1/000002dd.htm payday loan online free blackjack free blackjack http://www.freewebs.com/casino-45/blackjack-7.html play baccarat http://www.freewebs.com/casino-89/baccarat-6.html baccarat game http://www.freewebs.com/casino-31/roulette-6.html online casino roulette free online roulette loan till payday loan till payday http://www.jodoshinshu.com/discuss/_jodoshinshudiscuss/000018f5.htm

  8. 71.138.22.* 于 2007-06-28 23:32:13发表:

    faxless payday loan faxless payday loan http://eventplanning.com/plannerlink/_disc11/000000b1.htm savings account payday loan http://www.sflcoc.com/_sflgb/000016f4.htm savings account payday loan faxless payday loan faxless payday loan http://www.globalinkonline.com/_disc3/000001dc.htm http://www.thebluesband.com/webforum/_disc23/00003b71.htm no credit check payday loan no credit check payday loan free online blackjack http://www.freewebs.com/casino-89/blackjack-1.html free blackjack game

  9. 70.130.226.* 于 2007-06-28 23:28:06发表:

    cash advance paydayloans cash advance paydayloans http://www.mayfirstjobs.com/MayFirstJobs/00000047.htm http://kofc11020.org/_disc1/0000031c.htm payday advance loan payday advance loan payday cash loan payday cash loan http://www.thatreefguy.com/_board/00000f81.htm quik payday loan quik payday loan http://www.domeoverride.com/_disc1/00001df9.htm loan til payday loan til payday http://www.webservicesplus.com/_disc14/00002cbc.htm

  10. 83.34.19.* 于 2007-06-28 22:08:26发表:

    0b70387ca30ec9c82e81f9406b9f60e4 http://catalogoocchialesolerobertocavallo.ujgyzy.org/pes-6-guida-dei-migliore/ http://listino-soglia-marmo-pietra-vesuviana.jmcomw.org/ http://costo-servizio-trasporto-valore-privato.negvzz.org/ http://venditaingrossotovagliolocartanapoliprovincia.ujgyzy.org/disegni-per-bambini-sul-carnevale/ http://sport-site-sanihelp-msn-it.yigqdu.org/ http://visitamedicolegalesospensionepatente.fxbzoa.org/majestic-dvx-273-firmware-update/ http://catalogoocchialesolerobertocavallo.ujgyzy.org/bmw-320d-foto-cerchio-lega-155/ http://s-maria-maggiore-11-dicembre.meoprr.org/ http://windows-xp-non-si-spegne.negvzz.org/ http://video-musicale-due-si-baciano.yigqdu.org/ 24974b376644b5034250f73cecc2d1d6

  11. 196.32.128.* 于 2007-06-28 20:20:03发表:

    cheap payday loan cheap payday loan http://www.theinboxcafe.com/_disc1/000000a3.htm http://www.viennarose.com/_disc1/00005859.htm fax payday loan fax payday loan http://www.freewebs.com/casino-89/keno-1.html internet keno video keno savings account payday loan savings account payday loan http://www.lawtactics.com/_disc4/0000028c.htm video keno video keno http://www.freewebs.com/casino-82/keno-4.html

  12. 72.36.192.* 于 2007-06-28 15:24:44发表:

    Thank you!
    free slot machines games | sim slots | free casino slot games | pacific poker | online baccarat | no deposit bonus casinos | cleopatra slot | new free money online casinos | poker games download | poker software

  13. 72.36.192.* 于 2007-06-28 15:24:11发表:

    Thank you!
    play slot machines for free | black jack game | free online poker | video slot games | slim slots free | online free slots | free monopoly online | online video slots | free download poker | full tilt poker

  14. 72.36.192.* 于 2007-06-28 15:23:12发表:

    Thank you!
    play free roulette | online poker sites | free money casino | world series of poker download | blackjack free | world series of poker | free poker games | roulette download | free gambling | caribbean stud poker

  15. 72.36.192.* 于 2007-06-28 15:22:48发表:

    Good design!
    free poker games | joker poker | play roulette free | poker downloads | online gambling | online holdem | play free slots | casino deposit bonus | online strip blackjack | planet poker

  16. 72.36.192.* 于 2007-06-28 15:22:35发表:

    Thank you!
    free online slot machine | online free blackjack | free blackjack games | download slots | free slot games online | free online casino games | free casino slots | free games on line | bonus casino online | russian roulette game

  17. 24.254.35.* 于 2007-06-28 09:04:54发表:

    http://www.baatliv.no/_disc1/00002191.htm low fee payday loan low fee payday loan free craps game free craps game http://www.freewebs.com/casino-87/craps-5.html online keno video keno http://www.freewebs.com/casino-66/keno-6.html payday cash advance http://www.medinaarch.com/_techpark/00000105.htm payday cash advance payday loan personal payday loan personal http://www.115eastbackbay.com/_dailyNews/000000e5.htm

  18. 0.0.0.* 于 2007-06-28 08:30:00发表:

    free online blackjack game blackjack online http://www.freewebs.com/casino-24/blackjack-1.html payday cash advance http://www.lawtactics.com/_disc4/0000028a.htm payday cash advance http://www.esibirsi.net/Concorso/votazione/_disc1/000000d5.htm payday loan 1000 payday loan 1000 ez payday loan ez payday loan http://mavenmakeovers.com/TLC/00000051.htm keno casino free keno http://www.freewebs.com/casino-87/keno-7.html

  19. 0.0.0.* 于 2007-06-28 08:25:26发表:

    free casino games best online casino http://www.freewebs.com/casino-89/casino-4.html blogspot.com loan payday site blogspot.com loan payday site http://nc-code.com/_disc2/000007bb.htm seven card stud http://www.freewebs.com/casino-68/card-stud-6.html seven card stud quick payday loan quick payday loan http://www.elfrank.com/Blog/_disc1/00000c25.htm payday loan debt payday loan debt http://www.romstampa.it/_disc1/00000180.htm

  20. 207.61.242.* 于 2007-06-28 08:19:15发表:

    payday advance loan payday advance loan http://www.trufant.com/_disc1/000024ac.htm http://www.freewebs.com/casino-78/blackjack-5.html online blackjack game blackjack gambling payday loan personal payday loan personal http://www.business-bytes.com/forum/_disc2/00002636.htm blogspot.com fax loan no payday site blogspot.com fax loan no payday site http://www.blackhillsptcruisers.com/DiscussionWeb/_WDWGNext/00000232.htm easy payday loan easy payday loan http://www.nlcgwh.com/_disc3/000008d1.htm

  21. 0.0.0.* 于 2007-06-28 08:16:14发表:

    no teletrack payday loan no teletrack payday loan http://www.kityanpoetry.com/community/_disc7/00001122.htm bad credit payday loan bad credit payday loan http://vikimason.com/_disc3/0000083c.htm http://www.freewebs.com/casino-76/craps-6.html gambling craps online craps easy payday loan http://www.papillonphotos.com/_disc1/00001738.htm easy payday loan http://www.freewebs.com/casino-24/card-stud-2.html 7 card stud 7 card stud

  22. 155.212.33.* 于 2007-06-28 08:13:57发表:

    http://www.sflcoc.com/_sflgb/000016ef.htm payday loan store payday loan store http://donne.dconline.info/forum/_disc27/00000430.htm loan till payday loan till payday free baccarat play baccarat http://www.freewebs.com/casino-44/baccarat-6.html free online baccarat baccarat game http://www.freewebs.com/casino-44/baccarat-1.html low fee payday loan low fee payday loan http://www.gaitedhorsebooks.com/_disc50/000007f8.htm

  23. 195.43.241.* 于 2007-06-28 08:13:53发表:

    http://www.sflcoc.com/_sflgb/000016ef.htm payday loan store payday loan store http://donne.dconline.info/forum/_disc27/00000430.htm loan till payday loan till payday free baccarat play baccarat http://www.freewebs.com/casino-44/baccarat-6.html free online baccarat baccarat game http://www.freewebs.com/casino-44/baccarat-1.html low fee payday loan low fee payday loan http://www.gaitedhorsebooks.com/_disc50/000007f8.htm

  24. 0.0.0.* 于 2007-06-28 07:10:41发表:

    payday loan company payday loan company http://www.haircountry.com/_forum/00001fba.htm payday loan store payday loan store http://mavenmakeovers.com/TLC/00000052.htm gambling craps craps table http://www.freewebs.com/casino-78/craps-6.html casino roulette roulette game http://www.freewebs.com/casino-97/roulette-5.html seven card stud seven card stud http://www.freewebs.com/casino-87/card-stud-2.html

  25. 74.138.53.* 于 2007-06-28 06:19:45发表:

    casino slots las vegas casino http://www.freewebs.com/casino-13/casino-1.html loan till payday http://www.mby2.com/_cusudi/0000004d.htm loan till payday http://www.ragazzinet.it/Forum/Animali/_disc1/00000192.htm faxless payday loan faxless payday loan seven card stud http://www.freewebs.com/casino-76/card-stud-7.html 7 card stud http://www.freewebs.com/casino-44/casino-5.html las vegas casino casino gaming

  26. 72.181.153.* 于 2007-06-28 05:58:28发表:

    free online roulette roulette table http://www.freewebs.com/casino-97/roulette-1.html payday loan 1000 http://www.aromaticsage.com/_disc10/00000780.htm payday loan 1000 payday loan canada http://www.homeroom.net/_board/00000743.htm payday loan canada payday cash loan payday cash loan http://www.thebluesband.com/webforum/_disc23/00003b70.htm http://www.southatlantatouringgroup.com/MessageBoard/0000042c.htm fast cash payday loan fast cash payday loan

  27. 75.40.204.* 于 2007-06-28 05:24:32发表:

    http://www.marysvilleteachers.org/forum/_MUTAdiscussion/0000068b.htm quik payday loan quik payday loan cash til payday loan cash til payday loan http://thetrainingclinic.com/_disc1/000008d7.htm cash advance paydayloans cash advance paydayloans http://www.stonerville.com/forum/_disc1/00000033.htm fast payday loan http://www.solvepc.com/forum/_disc/0000019d.htm fast payday loan http://www.azodchat.com/freshwaterclassifieds/_disc24/00000559.htm money tree payday loan money tree payday loan

  28. 68.47.13.* 于 2007-06-28 04:43:06发表:

    http://www.dcsselect.eu/_disc1/000002de.htm loan till payday loan till payday bad credit payday loan bad credit payday loan http://www.gaston.k12.nc.us/departments/dec/CECAS/00001baf.htm http://www.freewebs.com/casino-45/craps-3.html gambling craps gambling craps play roulette online roulette tip http://www.freewebs.com/casino-31/roulette-7.html http://www.globalduk.com/_disc1/00000266.htm payday loan canada payday loan canada

  29. 0.0.0.* 于 2007-06-28 04:41:25发表:

    http://www.freewebs.com/casino-76/roulette-6.html online casino roulette online casino roulette baccarat online free baccarat http://www.freewebs.com/casino-97/baccarat-2.html http://www.gallery21online.com/_disc1/000001d2.htm faxless payday loan faxless payday loan bad debt loan payday http://www.bobtodaro.com/BTMUSIC/00000bd9.htm bad debt loan payday http://www.freewebs.com/casino-89/blackjack-3.html blackjack odds play free blackjack

  30. 0.0.0.* 于 2007-06-28 04:23:25发表:

    http://www.democraziacristianaonline.info/Appuntamenti/_disc29/00000087.htm bad debt loan payday bad debt loan payday http://www.freewebs.com/casino-13/slots-6.html video slots online casino slots play free blackjack http://www.freewebs.com/casino-78/blackjack-7.html play free blackjack http://www.tazenda.net/discussion/_disc1/00000eac.htm instant faxless payday loan instant faxless payday loan keno casino http://www.freewebs.com/casino-45/keno-6.html keno online

  31. 24.192.192.* 于 2007-06-28 04:03:23发表:

    http://www.freewebs.com/casino-89/keno-7.html free keno games keno casino fax payday loan fax payday loan http://www.cocoanutheads.com/_discussion-group/0000009a.htm roulette game online roulette gambling http://www.freewebs.com/casino-24/roulette-4.html http://www.socraticsocietyuvalde.org/socraticforum/_disc1/00001ea1.htm blogspot.com fax loan no payday site blogspot.com fax loan no payday site cash until payday loan cash until payday loan http://www.ucasal.net/diplomatura/primera_edicion/10_construccion_detesina/_disc16/00000d29.htm

  32. 68.61.186.* 于 2007-06-28 03:55:46发表:

    savings account payday loan savings account payday loan http://www.springgreen.com/_bboard/00002891.htm bad credit payday loan http://www.esibirsi.net/Concorso/votazione/_disc1/000000d6.htm bad credit payday loan video keno video keno http://www.freewebs.com/casino-78/keno-1.html seven card stud 7 card stud http://www.freewebs.com/casino-13/card-stud-5.html payday loan on line http://www.romstampa.it/_disc1/0000017f.htm payday loan on line

  33. 24.239.87.* 于 2007-06-28 03:49:34发表:

    payday loan personal http://www.southwark.anglican.org/encounter/_disc1/00003bc4.htm payday loan personal play craps online free free craps http://www.freewebs.com/casino-13/craps-6.html http://www.freewebs.com/casino-76/blackjack-1.html blackjack online jack black free slots casino slots http://www.freewebs.com/casino-13/slots-7.html craps rules http://www.freewebs.com/casino-76/craps-5.html free craps game

  34. 68.7.15.* 于 2007-06-28 03:39:07发表:

    instant payday loan instant payday loan http://stone.co.za/_rossouw/00000073.htm payday loan debt payday loan debt http://home.houston.rr.com/larryandevelyn/_disc1/000000d3.htm low fee payday loan http://www.hypocrats.org/_discussion/00000145.htm low fee payday loan seven card stud http://www.freewebs.com/casino-78/card-stud-4.html 7 card stud blogspot.com loan payday site blogspot.com loan payday site http://www.lawtactics.com/_disc4/0000028b.htm

  35. 200.60.143.* 于 2007-06-28 03:09:30发表:

    loan til payday loan til payday http://www.birdbrainsolutions.com/birdbrainforum/BeakSpeak/0000007a.htm no faxing payday loan no faxing payday loan http://www.denormalization.com/BLOG/Discussions/0000005e.htm online casino game best online casino gambling http://www.freewebs.com/casino-76/casino-7.html http://www.freewebs.com/casino-31/card-stud-1.html seven card stud 7 card stud savings account payday loan http://www.allfearless.com/timinator/longmont/_disc1/00001483.htm savings account payday loan

  36. 77.70.106.* 于 2007-06-28 03:09:09发表:

    loan til payday loan til payday http://www.birdbrainsolutions.com/birdbrainforum/BeakSpeak/0000007a.htm no faxing payday loan no faxing payday loan http://www.denormalization.com/BLOG/Discussions/0000005e.htm online casino game best online casino gambling http://www.freewebs.com/casino-76/casino-7.html http://www.freewebs.com/casino-31/card-stud-1.html seven card stud 7 card stud savings account payday loan http://www.allfearless.com/timinator/longmont/_disc1/00001483.htm savings account payday loan

  37. 61.250.95.* 于 2007-06-28 03:08:18发表:

    instant payday loan instant payday loan http://www.doeverythingtoglorifygod.com/gg/0000094c.htm bad debt loan payday http://www.mooseheadband.com/_disc3/000000ed.htm bad debt loan payday free online keno free keno http://www.freewebs.com/casino-24/keno-3.html casino games online casino gambling http://www.freewebs.com/casino-97/casino-4.html http://amitechnologies-inc.com/_cusudi/000003bf.htm payday loan on line payday loan on line

  38. 202.64.220.* 于 2007-06-27 23:44:07发表:

    instant payday loan instant payday loan http://kreacom.com/_scd1/000000b2.htm payday loan online payday loan online http://jobinsurance.com/ble624/_div624bb/00000534.htm online casino slots free slots machine game http://www.freewebs.com/casino-53/slots-3.html internet keno internet keno http://www.freewebs.com/casino-24/keno-7.html payday loan payday loan http://www.stmichaelsingles.com/_openforum/00001186.htm

  39. 0.0.0.* 于 2007-06-27 19:43:22发表:

    loan till payday loan till payday http://www.haime.com.ar/_disc1/00000dc9.htm slots online slots online http://www.freewebs.com/casino-89/slots-3.html money tree payday loan money tree payday loan http://www.drgho.com/m607hm65/_disc607/0000014e.htm payday loan payday loan http://fieldandfelt.com/emailshootingleagues/_disc10/00000ed2.htm http://www.socraticsocietyuvalde.org/socraticforum/_disc1/00001ea4.htm loan till payday loan till payday

  40. 72.36.192.* 于 2007-06-27 18:45:40发表:

    Good design!
    motorola razr v3 ringtones | nokia free ringtones | free ringtone converter | free ringtones for t-mobile | free polyphonic | free alltel ringtones | motorola ringtones free | alltel free ringtones

  1. 首页上一页 15 16 17 18 19 下一页 尾页

频道文章

最新教程

随机推荐

关于我们 | 合作 | 联系我们

© linuxdiyf.com 红联Linux门户 版权所有