红联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. 72.36.211.* 于 2007-08-15 20:47:11发表:

    Nice site!
    play slot machines for free | play roulette online | free slot | cash bingo | pai gow poker | poker for fun | free slot downloads | free sim slots | play texas holdem online | free casino

  2. 203.223.159.* 于 2007-08-15 18:23:06发表:

    Thanks boys :
    free mp3 = download music free = download music for free = how to download music = how to download music = FREE MUSIC DOWNLOADS = mp3 downloads = free music = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html download free music :: http://mywebpage.netscape.com/music5site/download-music.htm free music ipods :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free ipod music downloads :: http://musicdownloads4free.angelfire.com/free-music.html free mp3 music downloads :: http://www.fixgrout.com/cgi/musicpage35.html free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://mywebpage.netscape.com/music5site/download-music.htm free music for ipod :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free music video ::
    free mp3 .. music downloads .. free country music downloads .. download music video .. music downloads .. download music for free .. music downloads pc ..

  3. 203.121.67.* 于 2007-08-15 15:26:36发表:

    Great boys :
    free mp3 = free music downloads = download music free = free legal music downloads = free music for ipod = legal music downloads = free music video = download free music = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html music download :: http://mywebpage.netscape.com/music5site/download-music.htm free music download :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free mp3 :: http://musicdownloads4free.angelfire.com/free-music.html free ipod music downloads sites :: http://www.fixgrout.com/cgi/musicpage35.html limewire music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm download music free :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free music downloading ::
    free mp3 .. free ipod music downloads .. limewire music downloads .. free ipod music downloads .. music downloads pc .. mp3 downloads .. free download music ..

  4. 203.121.67.* 于 2007-08-15 15:02:42发表:

    Hi, my sites: :
    free mp3 = FREE MUSIC DOWNLOADS = music downloads = download music video = limewire = free music downloads = limewire music downloads = classical music downloads = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free music video :: http://mywebpage.netscape.com/music5site/download-music.htm limewire :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free ipod music downloads sites :: http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage35.html download music video :: http://www.fixgrout.com/cgi/musicpage31.html free music to download :: http://mywebpage.netscape.com/music5site/download-music.htm free music to download :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free music download ::
    free mp3 .. FREE MUSIC DOWNLOADS .. classical music downloads .. free mp3 downloads .. limewire music downloads .. free legal music downloads .. music downloads pc ..

  5. 72.36.211.* 于 2007-08-14 16:43:14发表:

    Good design!
    2008 usa president bet | nfl pro pick | mlb odds | rugby world cup bet | bet tips | best betting | british open odds | rugby union betting | 2008 party win election bets | nascar odds to win

  6. 72.36.211.* 于 2007-08-14 16:42:48发表:

    Great work!
    betting site | bet odds | nfl football lines | bet top 10 | canadian football spreads | wnba lines | line football betting | us major league soccer | baseball stats | golf odds

  7. 72.36.211.* 于 2007-08-14 16:41:50发表:

    Well done!
    handicapping horse | sport betting tip | ufc betting | golf props | handicapping nfl | top sportsbook | english premier league bet | 2007 cricket world cup bet | horse racing betting tip | formula one futures

  8. 72.36.211.* 于 2007-08-14 16:41:26发表:

    Good design!
    boxing props | pga futures | horse racing betting | 2007 davis cup odds | english football online bet | test cricket bet | thoroughbred racing | bet com | baseball gambling | nfl sportsbook

  9. 72.36.211.* 于 2007-08-14 16:41:15发表:

    Great work!
    nascar props | odds on basketball | mlb run line | nfl line odds | virtual betting | odds to win superbowl 2008 | nfl odds | wnba props | betting exchange | handicapping horse race

  10. 72.36.211.* 于 2007-08-13 14:24:41发表:

    Great work!
    download free poker | free texas holdem | bingo fun | poker games online | free slots for fun | online baccarat | play bingo | texas poker | online roulette free | free casino slots

  11. 72.36.211.* 于 2007-08-13 14:24:05发表:

    Nice site!
    free slot machine play | best online casinos | internet casino games | bingo game web | free play slots | internet blackjack | no download slots | gambling games | blackjack free games | free video slot games

  12. 72.36.211.* 于 2007-08-13 14:23:24发表:

    Thank you!
    slot machine | free internet poker | play bingo now | free poker games online | free slots download | where to play bingo | blackjack strip | free online poker | online free slots | free blackjack games

  13. 72.36.211.* 于 2007-08-13 14:23:05发表:

    Great work!
    video poker | bingo mania | download casino | free online casinos | blackjack free | monopoly online | cleopatra slot machine | free poker online | new no deposit online casinos | on line gambling

  14. 72.36.211.* 于 2007-08-13 14:22:53发表:

    Well done!
    black jack online | live poker | russian roulette games | no download casino | roulette game | holdem poker | texas holdem poker | free black jack | play casino games | free poker downloads

  15. 60.176.198.* 于 2007-08-13 07:51:19发表:

    原子吸收光谱仪

  16. 72.36.211.* 于 2007-08-12 09:24:13发表:

    Thank you!
    centennial wireless ringtones | free mp3 ringtone | nelly furtado ringtones | free ringtones for nokia | free midi ringtones | beyonce ringtones | ringtones composer | samsung melodi | free kyocera ringtones | sprint pcs ringtones

  17. 72.36.211.* 于 2007-08-12 09:23:52发表:

    Good design!
    download free polyphonic ringtones | download free nokia ringtone | suonerie telefonini | free hifi ringtones | free nextel downloads | ringtones para celular | razr v3 ringtones | hudba mp3 | ringtones for motorola q | free 24 ctu ringtone

  18. 72.36.211.* 于 2007-08-12 09:22:45发表:

    Nice site!
    free ringtones for samsung | mp3 ringtones download | dzwonki do nokii | ringtones for us cellular | goedkoopste ringtones | free lg ringtones | klingelton download | ringtones for verizon | 24 ctu ringtone verizon | tracfone free ringtones

  19. 72.36.211.* 于 2007-08-12 09:22:21发表:

    Good design!
    crazy frog ringtones | toques gratis | free downloadable t mobile ringtones | free nextel ringtone downloads | free t mobile ringtones | tmobile ringtones | free harry potter ringtones | logo sonnerie | free anime ringtones | bedava cep melodi

  20. 72.36.211.* 于 2007-08-12 09:22:07发表:

    Nice site!
    free ringtones alltel | free phone ringtones | free ringtones lg | ringtones for motorola | keypress ringtones | free real tone ringtones | cellular south | free sprint ringtones | ringtones mp3 free | free blackberry ringtones

  21. 203.121.67.* 于 2007-08-12 00:43:06发表:

    Yhanks you :
    free mp3 = music downloads = FREE MUSIC DOWNLOADS = free music to download = free music for ipod = free ipod music downloads = how to download music = free legal music downloads = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html classical music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm FREE MUSIC DOWNLOADS :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds how to download music :: http://musicdownloads4free.angelfire.com/free-music.html download music video :: http://www.fixgrout.com/cgi/musicpage35.html download free music :: http://www.fixgrout.com/cgi/musicpage31.html download music for free :: http://mywebpage.netscape.com/music5site/download-music.htm music downloads pc :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html music download ::
    free mp3 .. free music video .. free music ipods .. FREE MUSIC DOWNLOADS .. free ipod music downloads sites .. free music download sites .. free music downloads ..

  22. 60.176.193.* 于 2007-08-11 23:28:15发表:

    welcome to buy wow gold.We supply cheap wow gold to reliable customers. welcome to wow gold,buy

  23. 203.223.159.* 于 2007-08-11 21:13:12发表:

    Yhanks you :
    free mp3 = download music video = free music ipods = free mp3 music downloads = free legal music downloads = Free Music Downloads = music download = FREE MUSIC DOWNLOADS = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html music :: http://mywebpage.netscape.com/music5site/download-music.htm free limewire :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music ipods :: http://musicdownloads4free.angelfire.com/free-music.html music download free :: http://www.fixgrout.com/cgi/musicpage35.html music download free :: http://www.fixgrout.com/cgi/musicpage31.html music :: http://mywebpage.netscape.com/music5site/download-music.htm download free music :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free mp3 ::
    free mp3 .. music .. Free Music Downloads .. free music downloading .. free music for ipod .. mp3 downloads .. free country music downloads ..

  24. 203.223.159.* 于 2007-08-11 21:13:09发表:

    Yhanks you :
    free mp3 = download music video = free music ipods = free mp3 music downloads = free legal music downloads = Free Music Downloads = music download = FREE MUSIC DOWNLOADS = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html music :: http://mywebpage.netscape.com/music5site/download-music.htm free limewire :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music ipods :: http://musicdownloads4free.angelfire.com/free-music.html music download free :: http://www.fixgrout.com/cgi/musicpage35.html music download free :: http://www.fixgrout.com/cgi/musicpage31.html music :: http://mywebpage.netscape.com/music5site/download-music.htm download free music :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free mp3 ::
    free mp3 .. music .. Free Music Downloads .. free music downloading .. free music for ipod .. mp3 downloads .. free country music downloads ..

  25. 72.36.211.* 于 2007-08-10 20:24:52发表:

    Thank you!
    nokia ringtones | christina aguilera ringtones | free ringtones for cingular | ringtone uploader | ctu ring tone | free lg ringtones | real ringtones | free suncom ringtones | cingular ringtones | blackberry ringtones

  26. 72.36.211.* 于 2007-08-10 20:24:12发表:

    Thank you!
    us cellular free ringtones | cellular south | wwe ringtones | free sprint pcs ringtones | polifonik melodi | free verizon ringtones | motorola ring tones | melodie zdarma | christian ringtones | sprint ringtones

  27. 72.36.211.* 于 2007-08-10 20:23:38发表:

    Nice site!
    composer ringtones | ringtones motorola | free gospel ringtones | free sms ringtones | sanyo ringtones | klingelton kostenlos | gratis klingelton | boost ringtones | country music ringtones | free ringtones for us cellular

  28. 72.36.211.* 于 2007-08-10 20:23:21发表:

    Great work!
    ringtone free | logo sonnerie | toques siemens | free mp3 ringtones download | free ringtones for u s cellular | tracfone free ringtones | samsung free ringtones | ringtone midi | darmowe dzwonki | wav ringtones

  29. 72.36.211.* 于 2007-08-10 20:23:09发表:

    Well done!
    free hi fi ringtones | free ringtones alltel | toques reais | ringtone creator | verizon ctu ringtone | mobiel ringtone | nextel downloads | free phone ringtones | free mobile phone ringtones | free real tone ringtones

  30. 72.36.211.* 于 2007-08-09 20:17:32发表:

    Nice site!
    bingo game online | online bingo sites | multiplayer poker | online video slots | bingo scotland | poker free | party poker | texas holdem | free casino downloads | play blackjack online

  31. 72.36.211.* 于 2007-08-09 20:16:55发表:

    Nice site!
    roulette download | internet poker | full tilt poker | virtual poker | caribbean poker | play poker | free online strip blackjack | on line poker | world poker | monopoly online

  32. 72.36.211.* 于 2007-08-09 20:16:13发表:

    Thank you!
    play slots | free slot game | jackpot bingo | pokerstars download | poker software | bingo mania | no deposit online casino | free cleopatra slots | play free blackjack | bingo games online

  33. 72.36.211.* 于 2007-08-09 20:15:56发表:

    Well done!
    free casino | no deposit bingo online | free online black jack | free online poker | gambling online | bingo gala uk | free blackjack online | free slot machines | free bingo online | strip blackjack

  34. 72.36.211.* 于 2007-08-09 20:15:45发表:

    Thank you!
    poker web sites | slot machines | casino slots | casino slot games | us poker sites | on line gambling | new free money online casinos | no deposit bingo | free online blackjack | free money no deposit

  35. 72.36.211.* 于 2007-08-08 20:24:44发表:

    Nice site!
    sim slots | joker poker | texas hold em free | free casino online | games download | free monopoly online | free poker | free strip blackjack | internet casino games | online poker games

  36. 72.36.211.* 于 2007-08-08 20:23:55发表:

    Thank you!
    on line casinos | free black jack | no limit texas hold em | free online slot machine games | free texas hold em online | play texas holdem | free bingo games | blackjack software | online games | pokerstars download

  37. 72.36.211.* 于 2007-08-08 20:23:24发表:

    Thank you!
    no deposit online casino | internet bingo game | bingo site | world series of poker | bingo no deposit | free download poker | play slot machines | play bingo free | poker games download | free online slot games

  38. 72.36.211.* 于 2007-08-08 20:23:07发表:

    Good design!
    free no deposit casinos | free casino downloads | roulette game | internet casino | free poker game download | free slots for fun | sims slots | poker downloads | slim slots free | free casino money

  39. 72.36.211.* 于 2007-08-08 20:22:58发表:

    Great work!
    internet bingo | free play slot machines | slot games free | online poker sites | best online casinos | free roulette online | gambling games | free internet poker | free poker games online | free blackjack online

  40. 72.36.211.* 于 2007-08-07 20:15:59发表:

    Nice site!
    gratis mobilspel | free ringtones for motorola | ringtones for motorola q | ringtones for cingular | mp3 to ringtone | country ringtones | free cellular ringtones | klingeltoene samsung | monophonic ringtones | free us cellular ringtones

  1. 首页上一页 3 4 5 6 7 下一页 尾页

频道文章

最新教程

随机推荐

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

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