红联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. 0.0.0.* 于 2007-02-17 21:10:29发表:

    win baccarat http://loyno.edu/~kdelk/new/baccarat/win-baccarat.html maquinas tragaperras web http://loyno.edu/~kestarr/news/es/maquinas-tragaperras/maquinas-tragaperras-web.html kostenlos videopoker spielen http://loyno.edu/~kestarr/news/de/video-poker/kostenlos-videopoker-spielen.html premios dinero portal internet http://loyno.edu/~kestarr/news/es/premio-dinero/premios-dinero-portal-internet.html juego gratis pagina web http://loyno.edu/~kestarr/news/es/juego-gratis/juego-gratis-pagina-web.html ganar premios online http://loyno.edu/~kestarr/news/es/ganar-premio/ganar-premios-online.html pai gow poker paginas internet http://loyno.edu/~kestarr/news/es/pai-gow/pai-gow-poker-paginas-internet.html play 5 card stud http://loyno.edu/~kdelk/new/card-stud/play-5-card-stud.html ruleta paginas web http://loyno.edu/~kestarr/news/es/roulette/ruleta-paginas-web.html baccarat portal http://loyno.edu/~kestarr/news/es/baccarat/baccarat-portal.html

  2. 0.0.0.* 于 2007-02-17 19:40:17发表:

    lil scrappy ringtones http://lilscrappyringtonesaiaeu.blogspot.com eminem ringtone http://eminemringtonevkat.blogspot.com free ringtone for sprint phone http://freeringtoneforsprintphonefifl.blogspot.com free kyocera ringtone http://freekyoceraringtonemiyfkb.blogspot.com free real music ringtones for nextel http://freerealmusicringtonesfornextelmial.blogspot.com free cingular cell phone ringtone http://freecingularcellphoneringtonerufw.blogspot.com free ringtone http://freeringtonehmt.blogspot.com download free sprint ringtones http://downloadfreesprintringtonesaktt.blogspot.com free motorola ringtone http://freemotorolaringtonebkbuml.blogspot.com free ringtone for sprint phone http://freeringtoneforsprintphonednynd.blogspot.com

  3. 213.240.225.* 于 2007-02-17 19:37:11发表:

    free music ringtone http://cringtones.t35.com/cingularringtones/free-ringtone.html hotlink maxis caller ringtones http://freringtone001.netfast.org/ringtones-4.html free ringtones http://ringtone5.fws1.com/free-ringtones-4.html kostenlose casinospiele http://www.pokerraume.150m.com/casino-spiele-3.html free ringtone http://freeringtones1.php0h.com/free-ringtone-2.html jeu en ligne gratuit http://pacpoker.2-hi.com/jeu-2.html jeu http://pokerenligne.50megs.com/jeu-poker-2.html jouez ligne http://jouezaupoker.prophp.org/jeu-2.html ja rule ringtone http://rngtones.20fr.com/ringtone-4.html casino en ligne http://jeudepoker.awardspace.com/online-casino-4.html

  4. 213.240.225.* 于 2007-02-17 17:45:39发表:

    kostenloses online poker spiel http://www.pokerraume.150m.com/online-poker-4.html free mobile ringtones http://ringtone.freewebsites.com/ringtones-2.html elvis presley ringtones http://cringtones.t35.com/cingularringtones/ringtones-4.html kiss ringtone http://www.cingringt.150m.com/ringtone-5.html caribean poker http://pokerspiele.fws1.com/poker-3.html dave hollister ringtone http://freeringtone.netfast.org/ringtone-2.html free t mobile ringtones http://rngtones.xlphp.net/free-ringtones-4.html kid a ringtone http://freringtone.xlphp.net/ringtone-2.html free cell phone ringtone http://freeringtones2.fws1.com/free-ringtone-4.html free verizon ringtones http://freringtone0001.150m.com/free-ringtones-2.html

  5. 213.240.225.* 于 2007-02-17 17:04:46发表:

    cheap carisoprodol http://cheapcarisoprodollnhmik.blogspot.com buy tramadol online http://buytramadolonlineefyl.blogspot.com buy vicodin http://buyvicodinbkkkrs.blogspot.com buy adipex online http://buyadipexonlinerwch.blogspot.com buy ambien http://buyambienleresk.blogspot.com buy meridia http://buymeridiamttlln.blogspot.com buy fioricet http://buyfioricethukpu.blogspot.com buy adipex online http://buyadipexonlineusen.blogspot.com buy celebrex http://buycelebrexaca.blogspot.com buy ambien http://buyambienuobso.blogspot.com

  6. 65.110.43.* 于 2007-02-17 07:22:23发表:

    Nice site!
    on line gambling | no deposit casinos | video slots | strip blackjack | poker download | free video slots | poker texas | free slots download | free slot games no download | poker stars download

  7. 72.232.250.* 于 2007-02-17 07:21:33发表:

    Thank you!
    free on line poker | online bingo games | monopoly online | poker free | online texas hold em | free texas hold em online | free bonus slots | free slot machine play | roulette online | internet gambling

  8. 72.232.63.* 于 2007-02-17 07:20:34发表:

    Nice site!
    video slots free | casino bonuses | texas hold em online | download casino | new free money online casinos | free texas holdem poker | monopoly slots | casino poker | texas poker | new no deposit casino

  9. 72.232.250.* 于 2007-02-17 07:20:10发表:

    Well done!
    russian roulette | free slot machine downloads | free online bingo | free gambling | black jack download | free slot games | casino slots | free slot machines games | slot machines free | online poker sites

  10. 72.232.250.* 于 2007-02-17 07:19:56发表:

    Nice site!
    poker on line | free strip black jack | free blackjack | russian roulette game | no deposit bonuses | world series of poker download | casino game download | black jack | free online casino games | computer poker

  11. 213.240.225.* 于 2007-02-16 20:12:28发表:

    drug online http://drugonlinelbgf.blogspot.com cheap tramadol http://cheaptramadollpns.blogspot.com buy hydrocodone online http://buyhydrocodoneonlinesyry.blogspot.com buy carisoprodol online http://buycarisoprodolonlinedpnpmp.blogspot.com buy vicodin online http://buyvicodinonlinecwymu.blogspot.com buy celexa http://buycelexasvfoyd.blogspot.com buy adipex online http://buyadipexonlinenrannr.blogspot.com buy fioricet http://buyfioricetrno.blogspot.com buy carisoprodol online http://buycarisoprodolonlineaclap.blogspot.com buy adipex online http://buyadipexonlinedwiwpr.blogspot.com

  12. 0.0.0.* 于 2007-02-16 17:02:36发表:

    mosquito ringtones http://mosquitoringtonespsp.blogspot.com born lyric ringtone http://bornlyricringtoneekasi.blogspot.com free nokia ringtones http://freenokiaringtonestrrpmh.blogspot.com download free ringtone http://downloadfreeringtoneptp.blogspot.com totally free ringtone http://totallyfreeringtonenldea.blogspot.com bright eyes ringtones http://brighteyesringtonesefy.blogspot.com cingular ringtone http://cingularringtonevnhb.blogspot.com eamon ringtones http://eamonringtonesftu.blogspot.com 3g for free ringtone http://3gforfreeringtonekcfkw.blogspot.com free music ringtones http://freemusicringtonesocot.blogspot.com

  13. 0.0.0.* 于 2007-02-16 17:00:13发表:

    free mosquito ringtone http://freemosquitoringtonebcc.blogspot.com psychedelic furs ringtones http://psychedelicfursringtonespmy.blogspot.com lil flip ringtones http://lilflipringtoneskuudv.blogspot.com free ringtones and wallpaper http://freeringtonesandwallpapervpetb.blogspot.com free cingular cell phone ringtone http://freecingularcellphoneringtonehaddf.blogspot.com free t mobile ringtones http://freetmobileringtonesncg.blogspot.com free music ringtone http://freemusicringtonerehe.blogspot.com lil wayne ringtone http://lilwayneringtoneabcriv.blogspot.com relient k ringtone http://relientkringtonehfmv.blogspot.com free cell phone ringtone http://freecellphoneringtonetbot.blogspot.com

  14. 0.0.0.* 于 2007-02-16 16:29:22发表:

    usher ringtone http://usherringtonebusv.blogspot.com the flaming lip ringtones http://theflaminglipringtoneshbvtl.blogspot.com reba mcentire ringtone http://rebamcentireringtonemufp.blogspot.com marilyn manson ringtone http://marilynmansonringtonedlkpb.blogspot.com download free ringtone http://downloadfreeringtoneeccw.blogspot.com ringtones for cingular com http://ringtonesforcingularcomfgtykw.blogspot.com ringtones maker http://ringtonesmakertiu.blogspot.com free hindi ringtone http://freehindiringtonesmr.blogspot.com linkin park ringtone http://linkinparkringtonevwpe.blogspot.com young gunz ringtones http://younggunzringtonesbnmt.blogspot.com

  15. 0.0.0.* 于 2007-02-16 15:11:00发表:

    lil flip ringtone http://lilflipringtonevnvd.blogspot.com free ringtone maker http://freeringtonemakeriav.blogspot.com free samsung ringtones http://freesamsungringtonesihke.blogspot.com free motorola ringtones http://freemotorolaringtoneshfte.blogspot.com ying yang twins ringtone http://yingyangtwinsringtoneeieg.blogspot.com free polyphonic ringtone http://freepolyphonicringtonepail.blogspot.com nine inch nail ringtones http://nineinchnailringtonesoopugf.blogspot.com free kyocera ringtone http://freekyoceraringtoneyiia.blogspot.com celtic frost ringtones http://celticfrostringtonesgpcvs.blogspot.com red hot chili pepper ringtone http://redhotchilipepperringtonehwb.blogspot.com

  16. 0.0.0.* 于 2007-02-16 13:41:45发表:

    free boost ringtones http://freeboostringtonescrn.blogspot.com eric clapton ringtone http://ericclaptonringtoneyglocf.blogspot.com remind ringtone http://remindringtoneyvo.blogspot.com sprint ringtones http://sprintringtonesdbi.blogspot.com free mobile phone ringtone http://freemobilephoneringtoneolnw.blogspot.com lose yourself ringtone http://loseyourselfringtonelwhd.blogspot.com download ringtone http://downloadringtoneknngt.blogspot.com free mobile phone ringtones http://freemobilephoneringtonesmrwaab.blogspot.com gundam ringtone http://gundamringtonemihmd.blogspot.com free cell phone ringtones http://freecellphoneringtonescuc.blogspot.com

  17. 0.0.0.* 于 2007-02-16 13:23:14发表:

    elvis presley ringtone http://elvispresleyringtonetdplen.blogspot.com free cell phone ringtones http://freecellphoneringtonesderfu.blogspot.com free samsung ringtones http://freesamsungringtonesfkn.blogspot.com gundam ringtone http://gundamringtonetivh.blogspot.com celtic frost ringtone http://celticfrostringtoneovo.blogspot.com psychedelic furs ringtones http://psychedelicfursringtonesdtyal.blogspot.com red hot chili pepper ringtones http://redhotchilipepperringtonesuuwe.blogspot.com red hot chili pepper ringtones http://redhotchilipepperringtonesowbpoy.blogspot.com t mobile ringtone http://tmobileringtonebrsim.blogspot.com tina turner ringtone http://tinaturnerringtonecalr.blogspot.com

  18. 213.240.225.* 于 2007-02-16 13:12:33发表:

    download free ringtones nokia http://downloadfreeringtonesnokiasbdm.blogspot.com caller ringtone http://callerringtoneahete.blogspot.com free christian ringtone http://freechristianringtoneyunett.blogspot.com lil wayne ringtones http://lilwayneringtoneskkf.blogspot.com free real ringtones http://freerealringtonesooak.blogspot.com free music ringtone http://freemusicringtonenyptm.blogspot.com free cricket ringtone http://freecricketringtoneatdtr.blogspot.com ringtone for cingular com http://ringtoneforcingularcomdwltlh.blogspot.com free ringtones for motorola phone http://freeringtonesformotorolaphonectc.blogspot.com free sony ericsson ringtones http://freesonyericssonringtonesimwpfn.blogspot.com

  19. 0.0.0.* 于 2007-02-16 12:11:09发表:

    free ringtones maker http://freeringtonesmakersdwsyo.blogspot.com 3g for free ringtone http://3gforfreeringtonetpwa.blogspot.com free christmas ringtones http://freechristmasringtonesukyc.blogspot.com depeche mode ringtones http://depechemoderingtonesevp.blogspot.com ringtone maker http://ringtonemakerfvdsm.blogspot.com free nextel ringtones http://freenextelringtoneshcg.blogspot.com nokia ringtones http://nokiaringtonesvfd.blogspot.com real music ringtones http://realmusicringtonesipcpcs.blogspot.com download free ringtones t mobile http://downloadfreeringtonestmobileltvkh.blogspot.com celtic frost ringtone http://celticfrostringtonetiul.blogspot.com

  20. 213.25.3.* 于 2007-02-16 09:27:27发表:

    download free ringtone nokia http://downloadfreeringtonenokiaboeni.blogspot.com dave hollister ringtone http://davehollisterringtonecibthb.blogspot.com cell phone ringtone http://cellphoneringtoneuuub.blogspot.com download free mp3 ringtones http://downloadfreemp3ringtonessvp.blogspot.com free suncom ringtone http://freesuncomringtonelibgsp.blogspot.com ying yang twins ringtone http://yingyangtwinsringtoneaelg.blogspot.com free sony ericsson ringtones http://freesonyericssonringtonesgdonb.blogspot.com ja rule ringtone http://jaruleringtonelfyecs.blogspot.com download free alltel ringtones http://downloadfreealltelringtonessvucsv.blogspot.com darude ringtones http://daruderingtoneshcba.blogspot.com

  21. 0.0.0.* 于 2007-02-16 09:17:16发表:

    download free ringtone nokia http://downloadfreeringtonenokiaboeni.blogspot.com dave hollister ringtone http://davehollisterringtonecibthb.blogspot.com cell phone ringtone http://cellphoneringtoneuuub.blogspot.com download free mp3 ringtones http://downloadfreemp3ringtonessvp.blogspot.com free suncom ringtone http://freesuncomringtonelibgsp.blogspot.com ying yang twins ringtone http://yingyangtwinsringtoneaelg.blogspot.com free sony ericsson ringtones http://freesonyericssonringtonesgdonb.blogspot.com ja rule ringtone http://jaruleringtonelfyecs.blogspot.com download free alltel ringtones http://downloadfreealltelringtonessvucsv.blogspot.com darude ringtones http://daruderingtoneshcba.blogspot.com

  22. 213.240.225.* 于 2007-02-16 07:53:15发表:

    totally free ringtone http://totallyfreeringtonesvnid.blogspot.com black eyed pea ringtones http://blackeyedpearingtonesykw.blogspot.com dave hollister ringtones http://davehollisterringtonesaypvrv.blogspot.com n sync ringtone http://nsyncringtonepys.blogspot.com boyz east ringtones side http://boyzeastringtonessidehek.blogspot.com new ringtone http://newringtoneioihwy.blogspot.com free tracfone ringtone http://freetracfoneringtonekhlhbd.blogspot.com free kyocera ringtone http://freekyoceraringtoneysodal.blogspot.com beatles ringtone http://beatlesringtonetmlhed.blogspot.com the flaming lip ringtones http://theflaminglipringtonesnun.blogspot.com

  23. 213.240.225.* 于 2007-02-16 06:01:27发表:

    butterfly ringtone http://butterflyringtonekaccm.blogspot.com lil flip ringtone http://lilflipringtonekggcum.blogspot.com 50 cent ringtone http://50centringtoneaalav.blogspot.com download free ringtone nokia http://downloadfreeringtonenokiaryco.blogspot.com free mobile phone ringtone http://freemobilephoneringtoneabtbhh.blogspot.com free ringtone http://freeringtoneilodiw.blogspot.com 3g for free ringtone http://3gforfreeringtonewafoku.blogspot.com free boost mobile ringtone http://freeboostmobileringtonekvan.blogspot.com t mobile ringtone http://tmobileringtonefiermo.blogspot.com download free alltel ringtones http://downloadfreealltelringtonesfpeum.blogspot.com

  24. 213.240.225.* 于 2007-02-16 05:43:14发表:

    free ringtone http://gate.sinica.edu.tw/math/html/wwwboard/messages/31942.html free sprint ringtones http://aod.sinica.edu.tw/~pingpu/wwwboard/messages/1061.html beatles ringtones http://digilib.bu.edu:9080/theolib/Members/freshringtones11/ringtones-5.html free mobile ringtones http://www3.hpcf.upr.edu:8480/ElviaLab/Members/tonesringstones/free-ringtones-5.html free real music ringtone sprint http://freeringtones1.freecities.com/free-ringtone.html free ringtones http://getfreeringtones.fws1.com/free-ringtones.html kiss ringtones http://truja.lsi.upc.edu/mintaka/Members/ringtones199/ringtones.html ringtone http://gate.sinica.edu.tw/~pingpu/wwwboard/messages/939.html free us cellular ringtone http://freeringtones6.freewebspace.com/free-ringtone-5.html free ringtones http://web.ics.purdue.edu/~pucssa/modules/newbb/viewtopic.php?topic_id=62&post_id=78#forumpost78

  25. 213.240.225.* 于 2007-02-16 05:15:11发表:

    download free ringtone t mobile http://freeringtones.xlphp.net/free-ringtone.html free cricket ringtones http://www1.esc.edu/personalstu/sjohnus/ring/free-ringtones-5.html free real music ringtone for nextel http://freeringtone.freecities.com/free-ringtone-2.html free t mobile ringtone http://freeringtones111.xlphp.net/free-ringtone-2.html ringtones http://ringtonesnew.prophp.org/ringtones-4.html free ringtone http://freeringtones.sphosting.com/free-ringtone-4.html free ringtone http://truja.lsi.upc.edu/mintaka/Members/ringtones199/free-ringtone-5.html download free ringtone t mobile http://digilib.bu.edu:9080/theolib/Members/cellphoneringtones/free-ringtone-2.html free ringtones http://ustream.wcu.edu:8900/Members/ringsandtones/free-ringtones.html lil scrappy ringtones http://www.sinica.edu.tw/~pingpu/wwwboard/messages/1039.html

  26. 72.232.63.* 于 2007-02-15 22:53:08发表:

    Well done!
    texas holdem | cleopatra slots | poker games free | free video slot games | play slot machines | poker web sites | online slots free | free poker websites | free black jack games | casino on net

  27. 65.110.43.* 于 2007-02-15 22:52:44发表:

    Thank you!
    poker game free | free online slots no downloads | casino games online | video poker | new no deposit online casinos | cleopatra slot machine | russian roulette | texas hold em | poker for fun | free online poker

  28. 72.232.63.* 于 2007-02-15 22:52:23发表:

    Nice site!
    play free roulette | free three card poker | gambling machines | free games on line | poker online free | free bingo online | online casino | bingo games | joker poker | online free roulette

  29. 65.110.43.* 于 2007-02-15 22:52:08发表:

    Nice site!
    new no deposit casino | black jack game | free on line slots | free sims slots | online bingo games | free strip blackjack | free poker downloads | free slots for fun | holdem poker | casinos on line

  30. 72.232.63.* 于 2007-02-15 22:51:45发表:

    Great work!
    strip blackjack free | online poker free | casino bonuses | free online casino slots | video slots | online slots | online poker | strip blackjack | sims slots | free sim slots

  31. 66.36.241.* 于 2007-02-14 19:10:13发表:

    Great work!
    internet blackjack | free blackjack games | poker games download | new free money online casinos | virtual poker | poker websites | online poker games | casino slots | blackjack strip | joker poker

  32. 66.235.161.* 于 2007-02-14 19:09:36发表:

    Thank you!
    slot machine games | free bingo | absolute poker | slot games free | free slot machines games | bingo online | free slots downloads | poker free download | free slot games | slim slots free

  33. 65.110.43.* 于 2007-02-14 19:09:08发表:

    Nice site!
    free black jack | free slots no download | free roulette | free slot machines | russian roulette games | internet gambling | no deposit bonuses | strip blackjack games | keno online | play free slots online

  34. 65.110.43.* 于 2007-02-14 19:08:42发表:

    Good design!
    online gambling | free online strip blackjack | free video | games on line | casino free games | casino bonus | free texas holdem | hold em poker | full tilt poker | black jack games

  35. 65.110.43.* 于 2007-02-14 19:08:28发表:

    Great work!
    free money casino | roulette download | free slot games no download | online casino games | three card poker | poker game download | free poker online | no limit texas hold em | roulette online | poker on line

  36. 65.110.43.* 于 2007-02-13 20:05:05发表:

    Good design!
    free polyphonic ringtones order | free music ringtones | free real ringtones | cingular free ringtone siemens | free ringtones motorola v60i | compose motorola ringtones | nextel i730 ringtones free | download i730 nextel ringtone | free motorola v60i ringtones | download free nextel ringtones

  37. 72.232.63.* 于 2007-02-13 20:04:27发表:

    Good design!
    free polyphonic ringtones order | free music ringtones | free real ringtones | cingular free ringtone siemens | free ringtones motorola v60i | compose motorola ringtones | nextel i730 ringtones free | download i730 nextel ringtone | free motorola v60i ringtones | download free nextel ringtones

  38. 72.232.63.* 于 2007-02-13 20:03:04发表:

    Good design!
    free midi ringtones | gospel ringtones | free motorola ringtone downloads | cell phone ringtones | free polyphonic ringtones | free mp3 ringtones | free suncom ringtones | free verizon ringtones | free real music ringtones | free tracfone ringtones

  39. 72.232.63.* 于 2007-02-13 20:02:35发表:

    Thank you!
    free sprint ringtone downloads | downloads free phone ringtone | motorola ringtones free | kyocera ringtones | ringtones composer | free anime ringtones | free christian ringtones sprint | free mobile polyphonic ringtones | free ringtones | 24 ringtone

  40. 72.232.63.* 于 2007-02-13 20:02:35发表:

    Thank you!
    free sprint ringtone downloads | downloads free phone ringtone | motorola ringtones free | kyocera ringtones | ringtones composer | free anime ringtones | free christian ringtones sprint | free mobile polyphonic ringtones | free ringtones | 24 ringtone

  1. 首页上一页 54 55 56 57 58 下一页 尾页

频道文章

最新教程

随机推荐

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

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