初学者如何学习分析函数-红联Linux系统门户

经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。

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

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

72.36.192.* 于 2007-06-27 18:44:36发表:

72.36.192.* 于 2007-06-27 18:44:11发表:

72.36.192.* 于 2007-06-27 18:43:58发表:

83.141.171.* 于 2007-06-27 18:37:19发表:

03e29acbedf26c082c7dce397e0f13b3 http://niente-sesso-fino-al-matrimonio.udzkxj.org/ http://omniauto-it-magazine-articolo-1662.xzpkti.org/ http://problema-causati-latte-nidina-2.wknmyv.org/ http://lavoro-a-napoli-e-provincia.oacpyn.org/ http://il-fu-mattia-pascal-sintesi.mfsvnp.org/ http://inviare-curriculum-lavoro-settore-bancario.jyrxnc.org/ http://stampa-biglietto-augurio-natale-gratis.wknmyv.org/ http://universita-scienza-della-formazione-primaria.xzpkti.org/ http://giochi-da-fare-in-casa.awdhmg.org/ http://la-pioggia-nel-pineto-d-annunzio.oacpyn.org/ dff758ad4d024eb641677108bbbbea97

0.0.0.* 于 2007-06-27 17:27:42发表:

instant payday loan instant payday loan http://www.azodchat.com/freshwaterclassifieds/_disc24/0000055c.htm instant faxless payday loan http://procheapness.com/procheapness/_disc3/0000028b.htm instant faxless payday loan payday loan online http://donne.dconline.info/forum/_disc27/0000042e.htm payday loan online payday cash loan payday cash loan http://www.patriotpacksinc.org/discussions/_disc1/0000586a.htm payday loan http://www.stubtoft.com/_debat/00001ed3.htm payday loan

68.147.224.* 于 2007-06-27 17:23:46发表:

payday cash loan http://procheapness.com/procheapness/_disc3/0000028c.htm payday cash loan faxless payday loan faxless payday loan http://members.tripod.com/branhamhighforum/_disc13/00000414.htm easy payday loan easy payday loan http://www.mamm-mariag.it/_disc12/000000ff.htm loan til payday loan til payday http://www.theinboxcafe.com/_disc1/000000a2.htm craps game http://www.freewebs.com/casino-66/craps-5.html craps rules

0.0.0.* 于 2007-06-27 17:07:17发表:

keno online free keno http://www.freewebs.com/casino-53/keno-4.html internet keno http://www.freewebs.com/casino-66/keno-3.html free online keno seven card stud 7 card stud http://www.freewebs.com/casino-97/card-stud-3.html http://www.medinaarch.com/_techpark/00000106.htm quik payday loan quik payday loan payday loan online http://www.dgfoutdoors.com/_disc1/00000259.htm payday loan online

151.133.255.* 于 2007-06-27 16:47:08发表:

payday cash advance payday cash advance http://www.fourvalves.com/chat/00000071.htm online baccarat free online baccarat http://www.freewebs.com/casino-76/baccarat-6.html loan till payday loan till payday http://www.ebody-building.com/_disc3/00001c24.htm payday loan company payday loan company http://capitalcallcenter.com/_disc1/0000011a.htm ez payday loan ez payday loan http://www.cfpcf.org/_disc1/0000005e.htm

0.0.0.* 于 2007-06-27 16:46:53发表:

http://www.treillagenet.com/views/00003fa2.htm easy payday loan easy payday loan payday loan 1000 payday loan 1000 http://rlstaton.com/mymessageboard/_disc2/00001c42.htm baccarat online free baccarat http://www.freewebs.com/casino-13/baccarat-5.html ameriloan payday loan ameriloan payday loan http://www.doeverythingtoglorifygod.com/gg/0000094a.htm internet keno play keno online http://www.freewebs.com/casino-13/keno-4.html

204.48.128.* 于 2007-06-27 16:04:07发表:

http://www.freewebs.com/casino-44/craps-7.html online casino craps craps online low fee payday loan low fee payday loan http://www.polishnetwork.com/polishnetwork/_disc1/000034b4.htm free slots machine http://www.freewebs.com/casino-76/slots-2.html video slots http://www.haime.com.ar/_disc1/00000dc8.htm sonic payday loan sonic payday loan rules of craps how to play craps http://www.freewebs.com/casino-45/craps-1.html

0.0.0.* 于 2007-06-27 15:18:27发表:

loan till payday http://home.nc.rr.com/marktrail/_disc1/0000009c.htm loan till payday casino games http://www.freewebs.com/casino-66/casino-7.html casino games http://www.ispor.org/disc/_disc/00000f0e.htm easy payday loan easy payday loan http://www.booksbyrule.com/discb1/_disc3/00000269.htm cash til payday loan cash til payday loan http://applesoranges.us/videos/_disc22/000000d9.htm payday cash advance payday cash advance

75.32.104.* 于 2007-06-27 13:38:18发表:

roulette online roulette online http://www.freewebs.com/casino-24/roulette-2.html online casino blackjack blackjack online http://www.freewebs.com/casino-53/blackjack-2.html http://www.bong-hit.com/_BongBuzz/00000dc1.htm low fee payday loan low fee payday loan http://applesoranges.us/videos/_disc22/000000db.htm cash til payday loan cash til payday loan http://www.vereinsring-liederbach.de/_disc1/00000010.htm cash advance payday loan cash advance payday loan

0.0.0.* 于 2007-06-27 13:15:28发表:

cash til payday loan cash til payday loan http://www.barbaraboudion.com/_LT71DISCUSSION/0000006f.htm http://www.freewebs.com/casino-53/craps-7.html play craps craps rules cash advance paydayloans cash advance paydayloans http://enska.khi.is/ragnheidur/_disc17/00004bcc.htm 7 card stud seven card stud http://www.freewebs.com/casino-53/card-stud-2.html http://www.freewebs.com/casino-44/casino-7.html best online casino casino bonus

0.0.0.* 于 2007-06-27 12:46:54发表:

online payday loan online payday loan http://www.duderanchontario.com/_disc1/000008b8.htm play roulette http://www.freewebs.com/casino-76/roulette-7.html online casino roulette free roulette play roulette online http://www.freewebs.com/casino-89/roulette-5.html roulette gambling http://www.freewebs.com/casino-24/roulette-7.html roulette online payday loan canada payday loan canada http://www.elfrank.com/Blog/_disc1/00000c26.htm

0.0.0.* 于 2007-06-27 12:29:23发表:

cash until payday loan http://donne.dconline.info/forum/_disc27/0000042f.htm cash until payday loan free casino games http://www.freewebs.com/casino-44/casino-6.html internet casino casino on net http://www.freewebs.com/casino-76/casino-4.html casino poker no faxing payday loan http://www.cahunger.com/_disc1/000007db.htm no faxing payday loan http://www.gotobaker.com/_job1disc/0000009d.htm payday loan canada payday loan canada

0.0.0.* 于 2007-06-27 08:03:35发表:

best online casino gambling free casino http://www.freewebs.com/casino-53/casino-4.html instant faxless payday loan http://www.otegolittleleague.org/discussion/_disc1/00000db4.htm instant faxless payday loan http://www.mysharktank.com/discuss/_disc1/0000015a.htm savings account payday loan savings account payday loan no faxing payday loan no faxing payday loan http://www.trps.ptc.edu.tw/myweb2/_disc4/0000161c.htm fast cash payday loan fast cash payday loan http://cicerocitizen.org/blogfolder/00004038.htm

124.46.166.* 于 2007-06-27 07:07:26发表:

http://www.mcap.ms/_mcap1/0000007f.htm payday loan debt payday loan debt free online casino http://www.freewebs.com/casino-31/casino-5.html online casino cash advance paydayloans http://www.prhs.k12.ny.us/fac/tatkinso2/_disc2/00001086.htm cash advance paydayloans instant faxless payday loan instant faxless payday loan http://www.birdbrainsolutions.com/birdbrainforum/BeakSpeak/0000007b.htm online roulette game play roulette online http://www.freewebs.com/casino-31/roulette-5.html

70.161.126.* 于 2007-06-27 06:36:17发表:

http://www.freewebs.com/casino-76/roulette-1.html online casino roulette roulette online http://www.freewebs.com/casino-66/baccarat-6.html baccarat online baccarat game payday loan store payday loan store http://www.rememberingheroes.org/_disc2/00001207.htm cash advance payday loan http://www.socialnetworkforseniors.com/Poetry/0000004e.htm cash advance payday loan bad credit payday loan bad credit payday loan http://www.cdedi.org/CDED/00000034.htm

75.36.95.* 于 2007-06-27 06:31:57发表:

no teletrack payday loan no teletrack payday loan http://www.chaoselites.com/Discussion/000001d7.htm payday advance loan payday advance loan http://www.azodchat.com/freshwaterclassifieds/_disc24/0000055d.htm http://www.bong-hit.com/_BongBuzz/00000dc3.htm quick payday loan quick payday loan no faxing payday loan no faxing payday loan http://www.arbor-inc.biz/_disc9/000000ec.htm free online craps play craps http://www.freewebs.com/casino-53/craps-6.html

0.0.0.* 于 2007-06-27 06:29:38发表:

online keno http://www.freewebs.com/casino-66/keno-2.html online keno http://www.freewebs.com/casino-53/keno-2.html internet keno keno online craps rules how to play craps http://www.freewebs.com/casino-87/craps-3.html ez payday loan ez payday loan http://www.cmpatristate.com/myweb/discussions/00001467.htm no credit check payday loan no credit check payday loan http://colescrossing.net/_bulletinboard/00000138.htm

0.0.0.* 于 2007-06-27 06:26:33发表:

fast payday loan http://www.wildlocals.com/_disc1/00001252.htm fast payday loan play baccarat http://www.freewebs.com/casino-53/baccarat-3.html free baccarat free slots machine http://www.freewebs.com/casino-66/slots-7.html sim slots http://www.freewebs.com/casino-68/baccarat-7.html baccarat game online baccarat online craps free craps game http://www.freewebs.com/casino-13/craps-7.html

75.36.95.* 于 2007-06-27 06:06:49发表:

7 card stud 7 card stud http://www.freewebs.com/casino-76/card-stud-2.html payday loan on line payday loan on line http://www.iaap-satellite.org/_disc1/0000111e.htm loan til payday loan til payday http://www.copysoft.net/_disc1/00000d60.htm loan till payday loan till payday http://www.btpformationeure.fr/_disc1/00000047.htm 7 card stud seven card stud http://www.freewebs.com/casino-44/card-stud-2.html

75.32.104.* 于 2007-06-27 04:23:12发表:

free roulette roulette online http://www.freewebs.com/casino-24/roulette-3.html quick payday loan quick payday loan http://colescrossing.net/_bulletinboard/00000139.htm http://eventplanning.com/plannerlink/_disc11/000000b0.htm bad debt loan payday bad debt loan payday casino craps how to play craps http://www.freewebs.com/casino-78/craps-3.html http://www.freewebs.com/casino-66/card-stud-1.html 7 card stud 7 card stud

0.0.0.* 于 2007-06-27 03:54:34发表:

It is understood free party poker

89.238.130.* 于 2007-06-27 03:26:27发表:

Begin with free poker online

24.255.209.* 于 2007-06-27 02:55:21发表:

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

153.106.4.* 于 2007-06-27 02:54:22发表:

In fact poker games

0.0.0.* 于 2007-06-27 02:44:24发表:

Take texas holdem tournament

69.155.247.* 于 2007-06-27 02:23:35发表:

I am free texas hold em poker

0.0.0.* 于 2007-06-27 02:12:06发表:

Consolidate how to play texas hold em

213.60.38.* 于 2007-06-27 02:09:01发表:

Three online poker tournament

217.154.148.* 于 2007-06-27 02:06:25发表:

Probably partypoker

69.246.128.* 于 2007-06-27 02:05:59发表:

You free online texas hold em

0.0.0.* 于 2007-06-27 02:05:18发表:

Any kind of online poker rooms

71.89.62.* 于 2007-06-27 02:01:18发表:

If she party poker com

0.0.0.* 于 2007-06-27 01:59:36发表:

Exception free online poker game

0.0.0.* 于 2007-06-27 01:44:26发表:

Contact play poker

0.0.0.* 于 2007-06-27 01:33:09发表:

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

0.0.0.* 于 2007-06-27 01:26:58发表:

Complete online texas holdem

0.0.0.* 于 2007-06-27 01:25:27发表:

Change how to play texas hold em

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐