红联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-28 10:07:56发表:

    We read about your website everywhere and think that it's a wonderful idea. quick payday loan same day backgammon gambling buy viagra ameriloan cash advance elysium ringtone cash advance nassau consumer debt consolidation online casino gaming cingular ringtones play blackjack online free

  2. 83.16.113.* 于 2007-02-28 10:00:17发表:

    free nextel ringtones http://freenextelringtoneshcg.blogspot.com black eyed pea ringtone http://blackeyedpearingtonelryn.blogspot.com free jamster ringtone http://freejamsterringtonehdhpw.blogspot.com elvis presley ringtone http://elvispresleyringtoneedv.blogspot.com nokia ringtones http://nokiaringtonesewkw.blogspot.com nextel ringtones http://nextelringtoneshgt.blogspot.com black eyed pea ringtones http://blackeyedpearingtonesdul.blogspot.com red hot chili pepper ringtone http://redhotchilipepperringtonembysd.blogspot.com 3g for free ringtone http://3gforfreeringtonetpwa.blogspot.com relient k ringtone http://relientkringtoneeknugo.blogspot.com

  3. 72.232.250.* 于 2007-02-28 09:31:36发表:

    Thank you!
    video poker machines | online blackjack | slots online | poker for fun | gambling machines | free sims slots | no download slots | game slot | play poker online | slot machine

  4. 65.110.43.* 于 2007-02-28 09:31:15发表:

    Nice site!
    strip black jack | online casino games | games online | free monopoly online | virtual poker | free online slot games | internet bingo | online texas hold em | free blackjack | play bingo online

  5. 65.110.43.* 于 2007-02-28 09:30:37发表:

    Well done!
    free no download slots | poker downloads | omaha poker | no deposit casinos | world series poker | free slot machine downloads | casino games online | party poker | play free blackjack | online roulette

  6. 65.110.43.* 于 2007-02-28 09:30:18发表:

    Thank you!
    free slot game | online gambling sites | download casino | roulette game | free slot machine games online | slots games | roulette | aussie slots | free poker | download party poker

  7. 72.232.250.* 于 2007-02-28 09:29:47发表:

    Thank you!
    free sim slots | online casino | free money no deposit casinos | new casinos | russian roulette games | play texas holdem online | free slots | on line gambling | free money no deposit | poker game free

  8. 0.0.0.* 于 2007-02-28 02:09:57发表:

    We will definitely be checking in on a regular basis to see how the site is growing. free verizon ringtones britney spears ringtone lil wayne ringtone casino net bad credit payday loan dave hollister ringtone texas holdem download free texas holdem poker game jeu en ligne business cash advance

  9. 65.110.43.* 于 2007-02-27 09:43:05发表:

    Well done!
    ringtone mp3 | christian music ringtones | crazy frog ringtone | free ringtones for samsung | free ringtones lg | free u s cellular ringtones | free ringtones for sprint phones | free real music ringtones | ringtone midi | free motorola ringtone downloads

  10. 65.110.43.* 于 2007-02-27 09:42:36发表:

    Great work!
    cricket free ringtones | free lg ringtones | free mp3 ringtones | wav ringtones | nextel ringtones | free us cellular ring tones | free sanyo ringtones | mosquito ringtone | ctu ringtone verizon | ring tones

  11. 72.232.63.* 于 2007-02-27 09:42:07发表:

    Well done!
    samsung free ringtones | ringtone jukebox | free ringtones sprint | motorola ring tones | ringtones midi | tracfone free ringtones | verizon ringtones | ctu ringtones | us cellular free ringtones | free real ringtones

  12. 65.110.43.* 于 2007-02-27 09:41:40发表:

    Thank you!
    free mp3 ringtone download | free ringtones for tmobile | free alltel ringtones | free ringtones for suncom | free ringtones mp3 | mobile ringtones | alltel free ringtones | free nextel downloads | ringtone 24 ctu | ringtone 24

  13. 72.232.250.* 于 2007-02-27 09:41:22发表:

    Nice site!
    free nascar ringtones | free anime | star wars ringtones | free mp3 tones | cell phone ringtones | free ringtones cingular | free cell phone ringtones | keypress ringtones | free ringtones download | nokia download

  14. 65.110.43.* 于 2007-02-26 09:42:09发表:

    Great work!
    poker websites | free on line poker | play texas holdem online | strip blackjack game | roulette free | casinos online | free slot games no download | free blackjack games | monopoly slot machine | online free blackjack

  15. 65.110.43.* 于 2007-02-26 09:41:27发表:

    Well done!
    online poker | black jack free | texas hold em | world series poker | free poker websites | blackjack download | free casino cash | casino games | free poker software | online gambling sites

  16. 72.232.63.* 于 2007-02-26 09:41:03发表:

    Thank you!
    star poker | free poker downloads | free poker on line | slot machine games free | free strip blackjack | slot machine | poker game free | free slot machines games | free slot machine games | world series of poker

  17. 72.232.250.* 于 2007-02-26 09:40:25发表:

    Thank you!
    internet blackjack | texas hold em free | slots online | online holdem | no deposit casinos | play poker for free | poker games free | casino on net | roulette games | free online roulette

  18. 72.232.63.* 于 2007-02-26 09:40:10发表:

    Nice site!
    black jack game | no deposit bonus | slot machines free | free casino bonus | play bingo | poker for fun | sims free slots | free online games | play slot machines for free | casino download

  19. 0.0.0.* 于 2007-02-26 09:33:38发表:

    video poker game video poker tips http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=125 le top des casinos en ligne casino net http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=143 jeu jeu http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=140 online gambling casinos gratuits http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=127 gamme net jeu http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=133 jeu flash gratuit free roulette http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=109 online roulette game party poker bonus code http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=150 party poker bonus code casinos en ligne bonus des casinos en ligne http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=145 craps http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=128 craps http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=106 poker free online video poker

  20. 0.0.0.* 于 2007-02-26 09:28:36发表:

    http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=130 jeu java jeu gratuit free texas hold em http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=119 free texas hold em poker jeu casino gratuit http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=137 casino jeu jeu flash gratuit http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=132 jeu flash gratuit play free slots http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=114 play slots machine casino video poker free video poker http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=123 http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=146 les meilleures poker promotions les meilleures poker promotions casinos casino sans t??hargement http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=126 jeu de poker en ligne jeu de poker en ligne http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=148 party poker bonus party poker bonus http://cclab.ocit.edu.tw/yrlin/Detail.asp?TitleID=103

  21. 0.0.0.* 于 2007-02-26 06:38:43发表:

    buy vigrx http://bugs.atech.tufts.edu/secure/attachment/10197/buy-vigrx.html buy vigrx free cell phone ringtone free verizon ringtone http://bugs.atech.tufts.edu/secure/attachment/10171/free-ringtone-5.html http://bugs.atech.tufts.edu/secure/attachment/10201/levitra.html buy levitra levitra online viagra pill order viagra online http://bugs.atech.tufts.edu/secure/attachment/10206/viagra.html ringtones http://bugs.atech.tufts.edu/secure/attachment/10184/ringtones-3.html lone star ringtones http://bugs.atech.tufts.edu/secure/attachment/10169/free-ringtone-3.html download free ringtone t mobile free christmas ringtone http://bugs.atech.tufts.edu/secure/attachment/10207/vigrx.html vigrx side effects vigrx pill download free cingular ringtones http://bugs.atech.tufts.edu/secure/attachment/10172/free-ringtones.html free samsung ringtones generic cialis http://bugs.atech.tufts.edu/secure/attachment/10199/cialis.html cialis eamon ringtone http://bugs.atech.tufts.edu/secure/attachment/10177/ringtone.html nextel ringtone

  22. 213.240.225.* 于 2007-02-26 04:33:24发表:

    buy tramadol http://bugs.atech.tufts.edu/secure/attachment/10195/buy-tramadol.html buy tramadol free metro pcs ringtone http://bugs.atech.tufts.edu/secure/attachment/10168/free-ringtone-2.html free metro pcs ringtone ambien side effects ambien http://bugs.atech.tufts.edu/secure/attachment/10187/ambien.html http://bugs.atech.tufts.edu/secure/attachment/10170/free-ringtone-4.html free ringtone maker free ringtone buy carisoprodol http://bugs.atech.tufts.edu/secure/attachment/10189/buy-carisoprodol.html buy carisoprodol online pink floyd ringtone nextel ringtone http://bugs.atech.tufts.edu/secure/attachment/10180/ringtone-4.html verizon wireless ringtones http://bugs.atech.tufts.edu/secure/attachment/10185/ringtones-4.html ringtones buy levitra buy levitra http://bugs.atech.tufts.edu/secure/attachment/10192/buy-levitra.html http://bugs.atech.tufts.edu/secure/attachment/10175/free-ringtones-4.html download free cingular ringtones free tracfone ringtones tramadol ultram tramadol http://bugs.atech.tufts.edu/secure/attachment/10205/tramadol.html

  23. 0.0.0.* 于 2007-02-26 04:15:39发表:

    ringtone ringtone http://bugs.atech.tufts.edu/secure/attachment/10178/ringtone-2.html

  24. 72.232.250.* 于 2007-02-26 00:33:28发表:

    Well done!
    music ringtones | free cricket ringtones | anime ringtones | ringtone midi | ringtones verizon | cingular free ringtones | free ringtones for t-mobile | free suncom ringtones | centennial wireless | blackberry ringtones

  25. 72.232.250.* 于 2007-02-26 00:33:22发表:

    Nice site!
    free ringtones for t mobile | country ringtones | lg ringtones | star wars ringtone | free mp3 ringtones | free ringtones | ringtone download | mosquito ring tone | ringtone websites | motorola ring tones

  26. 72.232.250.* 于 2007-02-26 00:33:22发表:

    Nice site!
    free ringtones for t mobile | country ringtones | lg ringtones | star wars ringtone | free mp3 ringtones | free ringtones | ringtone download | mosquito ring tone | ringtone websites | motorola ring tones

  27. 72.232.250.* 于 2007-02-26 00:33:17发表:

    Good design!
    mosquito ringtone | ringtones composer | ringtones for motorola q | ringtones for cingular | 24 ctu ringtones | free mp3 ringtones download | sanyo ringtones | free ringtones for tracfone | free ringtone converter | free ringtones for samsung

  28. 65.110.43.* 于 2007-02-26 00:33:17发表:

    Nice site!
    free sprint pcs ringtones | wav ringtones | cellular south | free alltel ringtones | free ringtones download | free ringtones samsung | free ringtones for alltel | christian music ringtones | 24 ctu ringtone verizon | u s cellular ringtones

  29. 65.110.43.* 于 2007-02-26 00:33:15发表:

    Well done!
    music ringtones | free cricket ringtones | anime ringtones | ringtone midi | ringtones verizon | cingular free ringtones | free ringtones for t-mobile | free suncom ringtones | centennial wireless | blackberry ringtones

  30. 65.110.43.* 于 2007-02-26 00:33:13发表:

    Great work!
    sprint free ringtones | free harry potter ringtones | free downloadable ringtones | motorola ringtones free | 24 ctu ringtone | us cellular ring tones | motorola keypress ringtones | free real tone ringtones | free nokia ringtone | free ringtone download

  31. 219.153.49.* 于 2007-02-26 00:18:36发表:

    http://www1.esc.edu/personalstu/mdavids/dr/viagra.html viagra viagra buy tramadol buy tramadol http://www1.esc.edu/personalstu/mdavids/dr/buy-tramadol.html phentermine prescription http://www1.esc.edu/personalstu/mdavids/dr/phentermine.html phentermine diet http://www1.esc.edu/personalstu/mdavids/dr/levitra.html levitra online buy levitra http://www1.esc.edu/personalstu/mdavids/dr/buy-soma.html buy soma buy soma buy ambien ambien http://www1.esc.edu/personalstu/mdavids/dr/ambien.html vigrx vigrx http://www1.esc.edu/personalstu/mdavids/dr/vigrx.html http://www1.esc.edu/personalstu/mdavids/dr/carisoprodol.html order carisoprodol buy carisoprodol buy carisoprodol http://www1.esc.edu/personalstu/mdavids/dr/buy-carisoprodol.html buy carisoprodol sizepro penis enlargement pill http://www1.esc.edu/personalstu/mdavids/dr/penis-enlargement.html herbal penis enlargement

  32. 213.61.25.* 于 2007-02-26 00:18:21发表:

    http://www1.esc.edu/personalstu/mdavids/dr/buy-fioricet.html buy fioricet buy fioricet fioricet http://www1.esc.edu/personalstu/mdavids/dr/fioricet.html buy fioricet http://www1.esc.edu/personalstu/mdavids/dr/buy-phentermine.html buy phentermine buy phentermine online buy soma http://www1.esc.edu/personalstu/mdavids/dr/soma.html order soma buy cialis online buy tadalafil cialis http://www1.esc.edu/personalstu/mdavids/dr/buy-cialis.html buy viagra buy viagra http://www1.esc.edu/personalstu/mdavids/dr/buy-viagra.html buy tadalafil cialis buy tadalafil cialis http://www1.esc.edu/personalstu/mdavids/dr/cialis.html buy vigrx http://www1.esc.edu/personalstu/mdavids/dr/buy-vigrx.html buy vigrx tramadol cheap tramadol http://www1.esc.edu/personalstu/mdavids/dr/tramadol.html buy levitra buy levitra http://www1.esc.edu/personalstu/mdavids/dr/buy-levitra.html

  33. 216.68.104.* 于 2007-02-25 22:36:41发表:

    free ringtones free ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=848 http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=841 free ringtone free nextel ringtone pink floyd ringtone http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=850 ringtone free nextel ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=846 free sprint ringtones free verizon wireless ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=844 free ringtones free music ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=858 free mobile phone ringtones free ringtone download free ringtone http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=842 free mobile phone ringtones free ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=845 free verizon wireless ringtone free motorola ringtone http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=839 usher ringtones usher ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=857

  34. 129.41.250.* 于 2007-02-25 22:32:50发表:

    buy ambien buy ambien online http://www1.esc.edu/personalstu/mdavids/dr/buy-ambien.html

  35. 216.68.104.* 于 2007-02-25 20:33:10发表:

    ringtone ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8377 kid a ringtone the flaming lip ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8374 relient k ringtones relient k ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8376 ringtone maker http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8373 ringtone maker free mp3 ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8381 verizon ringtone limp bizkit ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8372 boyz east ringtone side 50 cent ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8378 linkin park ringtones free cell phone ringtone free ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8356 http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8368 nextel ringtone drive me crazy ringtone free polyphonic ringtone free ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8357

  36. 0.0.0.* 于 2007-02-25 20:32:29发表:

    http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8358 100 free ringtone free ringtone free real ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8360 free real ringtones free t mobile ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8352 free ringtone download free ringtones t mobile download free verizon ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8366 http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8363 free us cellular ringtones free us cellular ringtones 100 free ringtones free ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8361 free verizon cell phone ringtones free t mobile ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8364 free polyphonic ringtones free polyphonic ringtones http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8380 free ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8349 free polyphonic ringtone dance last ringtone download free verizon ringtone http://www.indiana.edu/~w211proj/w211g_bbs/w211g.cgi?read=8375

  37. 0.0.0.* 于 2007-02-25 20:18:19发表:

    payday loan las vegas payday loan las vegas http://loyno.edu/~pcollins/topic/payday/payday-loan-las-vegas.html advance cash cashadvancesusa.com loan online online payday http://loyno.edu/~pcollins/topic/payday/advance-cash-cashadvancesusa.com-loan-online-online-payday.html advance cash cashadvancesusa.com loan online online payday payday loan calculator payday loan calculator http://loyno.edu/~pcollins/topic/payday/payday-loan-calculator.html california christian debt consolidation california christian debt consolidation http://loyno.edu/~pcollins/topic/debt/california-christian-debt-consolidation.html cash advance cash advance http://loyno.edu/~pcollins/topic/cash/cash-advance.html

  38. 0.0.0.* 于 2007-02-25 20:16:38发表:

    no fax payday advance loan no fax payday advance loan http://loyno.edu/~pcollins/topic/payday/no-fax-payday-advance-loan.html debt consolidation home equity loan debt consolidation home equity loan http://loyno.edu/~pcollins/topic/debt/debt-consolidation-home-equity-loan.html http://loyno.edu/~pcollins/topic/payday/canadian-payday-loan.html canadian payday loan canadian payday loan debt consolidation services debt consolidation services http://loyno.edu/~pcollins/topic/debt/debt-consolidation-services.html payday loan canada http://loyno.edu/~pcollins/topic/payday/payday-loan-canada.html payday loan canada

  39. 0.0.0.* 于 2007-02-25 20:13:25发表:

    credit debt consolidation loan http://loyno.edu/~pcollins/topic/debt/credit-debt-consolidation-loan.html credit debt consolidation loan ameriloan cash advance http://loyno.edu/~pcollins/topic/cash/ameriloan-cash-advance.html ameriloan cash advance credit card debt consolidation credit card debt consolidation http://loyno.edu/~pcollins/topic/debt/credit-card-debt-consolidation.html http://loyno.edu/~pcollins/topic/debt/debt-consolidation-and-management.html debt consolidation and management debt consolidation and management cialis http://loyno.edu/~pcollins/topic/drugs/cialis.html viagra cialis

  40. 211.151.90.* 于 2007-02-25 19:31:21发表:

    cash advance austin cash advance austin http://loyno.edu/~pcollins/topic/cash/cash-advance-austin.html cash advance san antonio http://loyno.edu/~pcollins/topic/cash/cash-advance-san-antonio.html cash advance san antonio http://loyno.edu/~pcollins/topic/cash/ace-cash-advance.html ace cash advance ace cash advance emergency payday loan emergency payday loan http://loyno.edu/~pcollins/topic/payday/emergency-payday-loan.html http://loyno.edu/~pcollins/topic/cash/cash-advance-loan-online.html cash advance loan online cash advance loan online

  1. 首页上一页 45 46 47 48 49 下一页 尾页

频道文章

最新教程

随机推荐

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

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