红联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. 24.233.137.* 于 2007-06-22 07:03:45发表:

    http://www.freewebs.com/casino-89/card-stud-3.html seven card stud seven card stud free online craps http://www.freewebs.com/casino-66/craps-1.html free online craps ameriloan payday loan http://diaperswing.com/post/_dc1/0000006f.htm ameriloan payday loan savings account payday loan savings account payday loan http://statewide.vir.org/k12discuss/_disc1/0000534f.htm payday loan company payday loan company http://www.bhmvending.com/BVC_Forum/_forum/0000020d.htm

  2. 206.174.6.* 于 2007-06-22 06:26:26发表:

    cheap payday loan cheap payday loan http://www.packroute.com/forum/_disc6/000008ee.htm keno casino http://www.freewebs.com/casino-76/keno-1.html video keno http://www.freewebs.com/casino-45/baccarat-7.html free baccarat baccarat game roulette tip roulette online http://www.freewebs.com/casino-97/roulette-4.html faxless payday loan http://mycropthorne.co.uk/Forum/ParishPlan/00000060.htm faxless payday loan

  3. 75.108.51.* 于 2007-06-22 06:19:08发表:

    free slots no download sim slots http://www.freewebs.com/casino-53/slots-6.html loan til payday http://www.perryg.com/TheOwlsPerch/mywebs2/chatroom1/_Hisdisc1/0000007d.htm loan til payday cash advance payday loan cash advance payday loan http://www.mooseheadband.com/_disc3/000000ee.htm cash advance payday loan cash advance payday loan http://www.duderanchontario.com/_disc1/000008b9.htm free online baccarat casino baccarat http://www.freewebs.com/casino-66/baccarat-5.html

  4. 72.9.11.* 于 2007-06-22 06:07:39发表:

    cash until payday loan http://www.hurricanerunners.net/_disc1/00000098.htm cash until payday loan internet casino internet casino http://www.freewebs.com/casino-53/casino-3.html http://www.kityanpoetry.com/community/_disc7/00001121.htm savings account payday loan savings account payday loan http://www.freewebs.com/casino-24/card-stud-1.html seven card stud seven card stud instant faxless payday loan http://www.chelonian.com/_disc1/000004b9.htm instant faxless payday loan

  5. 68.185.197.* 于 2007-06-22 05:35:42发表:

    payday loan canada http://www.prhs.k12.ny.us/fac/tatkinso2/_disc2/00001085.htm payday loan canada http://www.hortari.com/disc1/000001f8.htm blogspot.com fax loan no payday site blogspot.com fax loan no payday site http://www.blackhillsptcruisers.com/DiscussionWeb/_WDWGNext/00000233.htm payday loan 1000 payday loan 1000 online casino craps online casino craps http://www.freewebs.com/casino-66/craps-2.html play free slots machine slots machine game http://www.freewebs.com/casino-44/slots-5.html

  6. 0.0.0.* 于 2007-06-22 05:27:46发表:

    http://www.freewebs.com/casino-31/baccarat-6.html baccarat online baccarat game online roulette casino roulette http://www.freewebs.com/casino-24/roulette-6.html bad credit payday loan bad credit payday loan http://www.virginiaweldon.com/_disc2/0000007c.htm http://www.freewebs.com/casino-13/casino-4.html casino poker casino gambling military payday loan http://cicerocitizen.org/blogfolder/00004037.htm military payday loan

  7. 0.0.0.* 于 2007-06-22 05:22:18发表:

    online baccarat http://www.freewebs.com/casino-13/baccarat-2.html play baccarat seven card stud 7 card stud http://www.freewebs.com/casino-68/card-stud-2.html http://www.painareas.com/_disc1/0000011b.htm no faxing payday loan no faxing payday loan payday loan company payday loan company http://www.classicmullet.com/_disc2/000024aa.htm payday advance loan http://www.powerdreamteam.com/members/_GEL/00000096.htm payday advance loan

  8. 0.0.0.* 于 2007-06-22 05:22:13发表:

    online roulette game online roulette game http://www.freewebs.com/casino-24/roulette-1.html military payday loan http://home.satx.rr.com/usedbooksiwhs/BooksForSale/0000004c.htm military payday loan roulette game roulette game http://www.freewebs.com/casino-89/roulette-2.html payday loan http://www.boatdrinx.com/discussion/astrid/Astriddisc/000004b1.htm payday loan casino gambling online casino gambling http://www.freewebs.com/casino-66/casino-3.html

  9. 222.124.197.* 于 2007-06-22 05:17:26发表:

    payday loan online payday loan online http://www.rajmaai.com/_rajmaai/0000088d.htm http://www.edaytradertax.com/_disc1/00000f29.htm payday loan on line payday loan on line play free blackjack play free blackjack http://www.freewebs.com/casino-78/blackjack-1.html sonic payday loan http://www.luxury-cruises-forum.com/_LuxuryCruises/0000061b.htm sonic payday loan instant faxless payday loan instant faxless payday loan http://www.grevemidtby.dk/Diskussion/000000c2.htm

  10. 200.78.117.* 于 2007-06-22 05:12:36发表:

    http://www.freewebs.com/casino-24/blackjack-2.html free blackjack game free blackjack ez payday loan http://www.gotobaker.com/_job1disc/0000009b.htm ez payday loan http://www.freewebs.com/casino-53/craps-3.html free craps game craps rules payday loan store http://www.azodchat.com/freshwaterclassifieds/_disc24/00000558.htm payday loan store ameriloan payday loan ameriloan payday loan http://www.hairsite.com/m337hm9/_disc337/00000047.htm

  11. 0.0.0.* 于 2007-06-22 04:59:20发表:

    money tree payday loan http://www.winsomewitness.com/_cusudi/000000c6.htm money tree payday loan http://www.freewebs.com/casino-68/blackjack-4.html free online blackjack free blackjack game 7 card stud http://www.freewebs.com/casino-87/card-stud-5.html seven card stud savings account payday loan savings account payday loan http://www.packroute.com/forum/_disc6/000008ed.htm quick payday loan quick payday loan http://cpb5332.k12.sd.us/_disc1/00000030.htm

  12. 0.0.0.* 于 2007-06-22 04:58:39发表:

    money tree payday loan http://www.winsomewitness.com/_cusudi/000000c6.htm money tree payday loan http://www.freewebs.com/casino-68/blackjack-4.html free online blackjack free blackjack game 7 card stud http://www.freewebs.com/casino-87/card-stud-5.html seven card stud savings account payday loan savings account payday loan http://www.packroute.com/forum/_disc6/000008ed.htm quick payday loan quick payday loan http://cpb5332.k12.sd.us/_disc1/00000030.htm

  13. 75.69.192.* 于 2007-06-22 04:55:55发表:

    http://www.freewebs.com/casino-68/roulette-1.html roulette online play roulette instant payday loan instant payday loan http://www.ebody-building.com/_disc3/00001c27.htm blogspot.com fax loan no payday site http://www.ideeimpegno.it/_disc1/000005c8.htm blogspot.com fax loan no payday site ez payday loan http://www.hortari.com/disc1/000001f9.htm ez payday loan seven card stud http://www.freewebs.com/casino-24/card-stud-4.html 7 card stud

  14. 0.0.0.* 于 2007-06-22 04:55:36发表:

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

  15. 72.129.170.* 于 2007-06-22 04:35:23发表:

    http://www.banffcentre.ca/bnmi/bridges/forum02/_forum/00000216.htm faxless payday loan faxless payday loan payday loan online payday loan online http://lincoln.k12.mi.us/Buildings/HS/bargardi/_disc1/000000bc.htm http://www.freewebs.com/casino-31/baccarat-4.html baccarat online online baccarat instant faxless payday loan instant faxless payday loan http://www.savannahslim.com/talkingSpirits/_disc1/0000024d.htm 7 card stud seven card stud http://www.freewebs.com/casino-13/card-stud-1.html

  16. 0.0.0.* 于 2007-06-22 04:08:31发表:

    loan til payday loan til payday http://timeforaction.org/_disc2/00000eda.htm http://virtual.yosemite.cc.ca.us/jcurl/jcurl/_disc1/00000c7c.htm ameriloan payday loan ameriloan payday loan no faxing payday loan no faxing payday loan http://www.11avenue.com/forum/_disc12/0000029d.htm online casino blackjack free online blackjack http://www.freewebs.com/casino-24/blackjack-7.html online baccarat http://www.freewebs.com/casino-68/baccarat-2.html online baccarat

  17. 0.0.0.* 于 2007-06-22 03:46:14发表:

    http://www.freewebs.com/casino-45/keno-1.html keno casino free keno games blogspot.com fax loan no payday site http://www.mooseheadband.com/_disc3/000000ef.htm blogspot.com fax loan no payday site http://www.freewebs.com/casino-66/slots-3.html free slots machine game free online slots quik payday loan quik payday loan http://paceware.net/_disc1/00002fb0.htm roulette table roulette table http://www.freewebs.com/casino-66/roulette-6.html

  18. 0.0.0.* 于 2007-06-22 02:55:08发表:

    play blackjack online blackjack gambling http://www.freewebs.com/casino-24/blackjack-5.html free keno games online keno http://www.freewebs.com/casino-53/keno-1.html money tree payday loan http://www.blenusmodels.com/_disc1/000004df.htm money tree payday loan payday advance loan payday advance loan http://www.hc.idv.tw/talkweb/_disc1/0000000a.htm slots game http://www.freewebs.com/casino-66/slots-4.html online slots machine

  19. 59.1.24.* 于 2007-06-21 16:50:38发表:

    http://www.leshartman.com/Band/Forum2/_disc8/000005d9.htm cash advance paydayloans cash advance paydayloans fast cash payday loan http://www.chelonian.com/_disc1/000004bb.htm fast cash payday loan 7 card stud seven card stud http://www.freewebs.com/casino-97/card-stud-2.html fax payday loan fax payday loan http://www.viennarose.com/_disc1/0000585c.htm http://www.freewebs.com/casino-89/slots-2.html progressive slots slots online

  20. 0.0.0.* 于 2007-06-21 15:26:46发表:

    best online casino las vegas casino http://www.freewebs.com/casino-53/casino-2.html http://www.freewebs.com/casino-89/baccarat-3.html play baccarat free baccarat slots online slots online http://www.freewebs.com/casino-97/slots-4.html quik payday loan http://www.purperofamily.org/_disc1/00000035.htm quik payday loan free online blackjack game http://www.freewebs.com/casino-66/blackjack-7.html casino blackjack

  21. 76.192.135.* 于 2007-06-21 14:38:40发表:

    bad debt loan payday http://www.globalinkonline.com/_disc3/000001dd.htm bad debt loan payday bad debt loan payday bad debt loan payday http://www.hackwith.com/blog/_disc1/000026e6.htm http://www.kentpullen.com/_disc1KentPullen/000001f5.htm payday loan debt payday loan debt http://www.freewebs.com/casino-89/craps-6.html online craps gambling craps instant payday loan instant payday loan http://home.nc.rr.com/marktrail/_disc1/0000009e.htm

  22. 0.0.0.* 于 2007-06-21 14:11:23发表:

    sonic payday loan sonic payday loan http://www.polioakpavilion.org/association/_talk_1/0000006f.htm payday loan online payday loan online http://www.taseminar.at/_disc1/000001fc.htm http://www.freewebs.com/casino-53/casino-5.html casino games free online casino money tree payday loan money tree payday loan http://thetrainingclinic.com/_disc1/000008d9.htm free baccarat http://www.freewebs.com/casino-31/baccarat-3.html baccarat game

  23. 0.0.0.* 于 2007-06-21 14:07:01发表:

    low fee payday loan low fee payday loan http://www.superslamcountdown.com/_Hunting_Alaska/0000004a.htm http://stone.co.za/_rossouw/00000074.htm payday advance loan payday advance loan payday loan online payday loan online http://www.tempoklubben.com/Diskusjon/disc13/000003cd.htm play slots free slots machine game http://www.freewebs.com/casino-87/slots-4.html casino baccarat baccarat online http://www.freewebs.com/casino-87/baccarat-4.html

  24. 24.126.254.* 于 2007-06-21 13:37:40发表:

    payday loan debt http://diaperswing.com/post/_dc1/0000006e.htm payday loan debt http://www.freewebs.com/casino-31/blackjack-3.html blackjack card game blackjack card game http://www.freewebs.com/casino-13/roulette-4.html online roulette gambling online roulette free online roulette free online roulette http://www.freewebs.com/casino-87/roulette-1.html play free slots machine http://www.freewebs.com/casino-89/slots-4.html progressive slots

  25. 0.0.0.* 于 2007-06-21 13:33:37发表:

    online payday loan online payday loan http://fouinax.com/FEM_FORUM/000000d2.htm payday advance loan payday advance loan http://www.writersandartists.com/_disc2writers/00000261.htm fax payday loan http://www.berrienbiographies.com/Discussion/0000000f.htm fax payday loan payday loan 1000 http://www.bikecenterpr.com/_disc2/000019c1.htm payday loan 1000 payday loan debt payday loan debt http://www.virginiaweldon.com/_disc2/0000007b.htm

  26. 67.81.235.* 于 2007-06-21 13:16:12发表:

    play free blackjack java blackjack http://www.freewebs.com/casino-76/blackjack-7.html http://www.freewebs.com/casino-31/blackjack-2.html play free blackjack casino blackjack http://www.freewebs.com/casino-24/casino-4.html casino poker casino bonus instant payday loan instant payday loan http://www.identityunit.com/_disc1/00000057.htm savings account payday loan savings account payday loan http://www.sandycreekconservancy.com/SCIForum/000000a4.htm

  27. 0.0.0.* 于 2007-06-21 12:50:10发表:

    free online roulette roulette casino game http://www.freewebs.com/casino-45/roulette-6.html blogspot.com loan payday site http://www.bhmvending.com/BVC_Forum/_forum/0000020b.htm blogspot.com loan payday site seven card stud 7 card stud http://www.freewebs.com/casino-97/card-stud-5.html free online blackjack http://www.freewebs.com/casino-68/blackjack-2.html blackjack gambling seven card stud 7 card stud http://www.freewebs.com/casino-68/card-stud-4.html

  28. 75.132.6.* 于 2007-06-21 12:42:43发表:

    faxless payday loan http://www.domanisocialista.it/mioweb15/_disc19/000009f8.htm faxless payday loan http://www.hortari.com/disc1/000001fa.htm fax payday loan fax payday loan online roulette free roulette http://www.freewebs.com/casino-76/roulette-2.html internet casino free online casino http://www.freewebs.com/casino-87/casino-3.html baccarat game free online baccarat http://www.freewebs.com/casino-45/baccarat-1.html

  29. 134.60.15.* 于 2007-06-21 12:42:22发表:

    ez payday loan ez payday loan http://www.cahunger.com/_disc1/000007dd.htm cash til payday loan cash til payday loan http://www.whichsideofthefence.com/_disc7/00000078.htm military payday loan military payday loan http://www.bikecenterpr.com/_disc2/000019c2.htm http://www.freewebs.com/casino-87/blackjack-4.html free online blackjack game online casino blackjack http://www.viennarose.com/_disc1/0000584b.htm fast cash payday loan fast cash payday loan

  30. 220.72.219.* 于 2007-06-21 12:39:46发表:

    fast cash payday loan http://www.elfrank.com/Blog/_disc1/00000c23.htm fast cash payday loan cash til payday loan cash til payday loan http://www.kentpullen.com/_disc1KentPullen/000001f7.htm http://www.freewebs.com/casino-76/card-stud-1.html seven card stud 7 card stud faxless payday loan faxless payday loan http://www.aunttee.com/Entries/0000003e.htm free online keno online keno http://www.freewebs.com/casino-82/keno-6.html

  31. 77.70.106.* 于 2007-06-21 12:36:32发表:

    7 card stud 7 card stud http://www.freewebs.com/casino-44/card-stud-1.html casino craps play craps online free http://www.freewebs.com/casino-76/craps-1.html quik payday loan quik payday loan http://www.vanuatu.usp.ac.fj/journo/_journo/00002d74.htm http://www.sticknrudder.net/myweb5/TW/00000796.htm quick payday loan quick payday loan no fax payday loan no fax payday loan http://www.complaign.com/_disc2/00000ed8.htm

  32. 71.56.221.* 于 2007-06-21 12:29:34发表:

    fast payday loan fast payday loan http://www.phimuepsilon.com/forum/_disc2/000039ec.htm play roulette http://www.freewebs.com/casino-87/roulette-7.html play roulette craps game craps game http://www.freewebs.com/casino-45/craps-2.html http://www.freewebs.com/casino-97/keno-1.html online keno online keno play free slots machine online casino slots http://www.freewebs.com/casino-76/slots-1.html

  33. 69.181.234.* 于 2007-06-21 11:51:34发表:

    payday loan online payday loan online http://www.winsomewitness.com/_cusudi/000000c5.htm sonic payday loan sonic payday loan http://www.thebluesband.com/webforum/_disc23/00003b6e.htm low fee payday loan low fee payday loan http://www.tourdepub.com/_smack/00001210.htm fast payday loan fast payday loan http://www.arteyforma.com/_disc1/00000037.htm cash advance payday loan cash advance payday loan http://www.johnburrowsproject.com/_kbas/0000004a.htm

  34. 69.81.60.* 于 2007-06-21 11:00:42发表:

    payday loan company http://www.dylanryanmay.com/_disc1/00000053.htm payday loan company internet keno online keno http://www.freewebs.com/casino-97/keno-4.html http://www.freewebs.com/casino-53/card-stud-4.html seven card stud 7 card stud ameriloan payday loan ameriloan payday loan http://lincoln.k12.mi.us/Buildings/HS/bargardi/_disc1/000000bd.htm cash advance paydayloans http://www.lettuceisnotenough.com/_PhD/00006a4e.htm cash advance paydayloans

  35. 209.169.73.* 于 2007-06-21 10:23:12发表:

    quick payday loan quick payday loan http://www.blenusmodels.com/_disc1/000004e2.htm free craps game http://www.freewebs.com/casino-31/craps-4.html rules of craps http://www.freewebs.com/casino-87/roulette-2.html online roulette poker online casino roulette sonic payday loan http://www.westofthejordan.com/_disc1/00000139.htm sonic payday loan play baccarat baccarat game http://www.freewebs.com/casino-53/baccarat-4.html

  36. 0.0.0.* 于 2007-06-21 10:20:00发表:

    seven card stud http://www.freewebs.com/casino-53/card-stud-6.html 7 card stud play craps http://www.freewebs.com/casino-24/craps-1.html gambling craps http://www.freewebs.com/casino-68/craps-4.html how to play craps free online craps blackjack gambling http://www.freewebs.com/casino-53/blackjack-3.html casino blackjack cash til payday loan cash til payday loan http://www.baatliv.no/_disc1/00002190.htm

  37. 68.47.211.* 于 2007-06-21 09:23:50发表:

    payday loan payday loan http://www.ucasal.net/diplomatura/primera_edicion/10_construccion_detesina/_disc16/00000d28.htm no credit check payday loan http://www.gaitedhorsebooks.com/_disc50/000007f7.htm no credit check payday loan online keno free keno games http://www.freewebs.com/casino-76/keno-3.html fax payday loan http://www.gerritdirkmaat.com/_disc4/000000ed.htm fax payday loan http://www.freewebs.com/casino-68/casino-3.html online casino casino gambling

  38. 71.60.104.* 于 2007-06-21 09:16:53发表:

    http://www.freewebs.com/casino-53/keno-5.html video keno internet keno fast payday loan fast payday loan http://kofc11020.org/_disc1/00000320.htm faxless payday loan faxless payday loan http://virtual.yosemite.cc.ca.us/jcurl/jcurl/_disc1/00000c7a.htm no fax payday loan no fax payday loan http://www.nldguide.com/_kbas/00000141.htm http://www.medinaarch.com/_techpark/00000107.htm low fee payday loan low fee payday loan

  39. 76.19.236.* 于 2007-06-21 07:59:12发表:

    http://www.phimuepsilon.com/forum/_disc2/000039ed.htm sonic payday loan sonic payday loan no credit check payday loan no credit check payday loan http://www.vikingnewz.org/web%20discussion/001/000000af.htm savings account payday loan savings account payday loan http://www.brahman.co.za/Discussion/_disc2/00002394.htm online blackjack game online blackjack game http://www.freewebs.com/casino-66/blackjack-3.html cash til payday loan http://www.boatdrinx.com/discussion/astrid/Astriddisc/000004b2.htm cash til payday loan

  40. 72.36.192.* 于 2007-06-21 07:54:37发表:

    Great work!
    free blackjack game | free mp3 ringtone download | slot game | free slot downloads | black jack strip | slot machine | three card poker | monopoly slot machine | online black jack | download poker

  1. 首页上一页 21 22 23 24 25 下一页 尾页

频道文章

最新教程

随机推荐

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

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