初学者如何学习分析函数-红联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

204.48.128.* 于 2007-06-26 02:28:35发表:

Complete pacific poker bonus code

0.0.0.* 于 2007-06-26 02:25:51发表:

Lots of video strip poker

0.0.0.* 于 2007-06-26 02:23:36发表:

seven card stud 7 card stud http://www.freewebs.com/casino-87/card-stud-3.html payday advance loan payday advance loan http://mavenmakeovers.com/TLC/00000053.htm free keno games http://www.freewebs.com/casino-76/keno-4.html free keno payday loan canada http://www.11avenue.com/forum/_disc12/000002a1.htm payday loan canada http://www.mrlutz.com/discussion/_disc2/000006a3.htm payday loan on line payday loan on line

0.0.0.* 于 2007-06-26 02:18:40发表:

There pacific poker download

0.0.0.* 于 2007-06-26 02:16:41发表:

It is understood poker video

75.126.146.* 于 2007-06-26 02:05:14发表:

Shall texas holdem poker online

196.40.11.* 于 2007-06-26 01:49:59发表:

Just like free poker online

83.179.241.* 于 2007-06-25 15:48:55发表:

03d78e0b06beefa3946868837358feab http://ciclo-di-produzione-acqua-minerale.abpato.org/ http://sistematuristicolocale5terre.gydeyj.org/un-tranquillo-weekend-di-paura/ http://traduzione-paris-hilton-nothing-this-world.xfnqjv.org/ http://stazionesciisticavalledaosta.yoogjn.org/sindrome-tunnel-carpale-esiste-gravidanza/ http://pistapermotoinitalia.wyselb.org/autoveicolo-sequestrati-posto-all-asta/ http://prezzo-biglietto-partita-napoli-parma.xfnqjv.org/ http://softwarerilevamentopresenzadipendentecomunale.wyselb.org/acqua-ossigenata-130-volumi-padova/ http://forum-attacco-preparato-mediato-chitarra.fcgpay.org/ http://lido-venezia-appartamento-affitto-vacanza.xfnqjv.org/ http://istituto-d-arte-f-menna.bvthee.org/ 245153f8fc5ca6b7c7f1325ac3918a81

125.120.139.* 于 2007-06-25 15:01:52发表:

0.0.0.* 于 2007-06-25 12:52:21发表:

Rate free video poker games

69.222.54.* 于 2007-06-25 12:44:21发表:

In the first case pacific poker download

0.0.0.* 于 2007-06-25 12:16:29发表:

Preview texas holdem download

0.0.0.* 于 2007-06-25 11:51:50发表:

instant faxless payday loan instant faxless payday loan http://www.homeroom.net/_board/00000742.htm 7 card stud http://www.freewebs.com/casino-68/card-stud-1.html seven card stud http://www.blbweb.co.za/2010/_disc1/00000522.htm payday loan personal payday loan personal cheap payday loan cheap payday loan http://paceware.net/_disc1/00002faa.htm online casino game casino poker http://www.freewebs.com/casino-89/casino-5.html

0.0.0.* 于 2007-06-25 11:32:14发表:

play blackjack play blackjack online free http://www.freewebs.com/casino-76/blackjack-6.html savings account payday loan savings account payday loan http://www.hawkman.org/tarot/forum/_disc1/00001c7b.htm http://www.freewebs.com/casino-66/blackjack-6.html play blackjack online free play blackjack online free online payday loan online payday loan http://home.houston.rr.com/larryandevelyn/_disc1/000000d4.htm free casino games las vegas casino http://www.freewebs.com/casino-68/casino-5.html

62.231.243.* 于 2007-06-25 11:04:56发表:

http://mycropthorne.co.uk/Forum/ParishPlan/0000005f.htm no teletrack payday loan no teletrack payday loan http://www.freewebs.com/casino-89/baccarat-2.html free baccarat free baccarat slots game online slots http://www.freewebs.com/casino-78/slots-1.html http://www.marysvilleteachers.org/forum/_MUTAdiscussion/0000068a.htm payday loan store payday loan store http://www.peru.no/Peru-Noruega/00001edd.htm cheap payday loan cheap payday loan

0.0.0.* 于 2007-06-25 11:00:32发表:

http://www.freewebs.com/casino-24/baccarat-4.html casino baccarat free baccarat http://www.freewebs.com/casino-66/craps-4.html craps game play craps online free no faxing payday loan no faxing payday loan http://www.splurging.com/discussion3/_disc22/00000297.htm blackjack game casino blackjack http://www.freewebs.com/casino-45/blackjack-5.html fax payday loan fax payday loan http://www.gaston.k12.nc.us/departments/dec/CECAS/00001bb0.htm

0.0.0.* 于 2007-06-25 10:50:29发表:

Let's start with online video poker

0.0.0.* 于 2007-06-25 10:37:29发表:

loan till payday loan till payday http://www.treillagenet.com/views/00003fa3.htm play free slots http://www.freewebs.com/casino-24/slots-4.html progressive slots ameriloan payday loan ameriloan payday loan http://members.tripod.com/stjoe1967/_disc1/00000018.htm blogspot.com fax loan no payday site blogspot.com fax loan no payday site http://www.westofthejordan.com/_disc1/0000013a.htm roulette online http://www.freewebs.com/casino-44/roulette-3.html internet roulette

203.167.76.* 于 2007-06-25 08:43:14发表:

As you see online video poker

85.25.140.* 于 2007-06-25 08:31:40发表:

One poker video

165.24.252.* 于 2007-06-25 08:31:19发表:

0.0.0.* 于 2007-06-25 08:29:32发表:

Is free party poker

203.167.76.* 于 2007-06-25 08:23:23发表:

There online poker games

69.81.60.* 于 2007-06-25 08:13:25发表:

Thanks free texas hold em

203.186.54.* 于 2007-06-25 08:13:24发表:

Similarly online poker

0.0.0.* 于 2007-06-25 08:13:10发表:

Furthermore partypoker

71.15.148.* 于 2007-06-25 08:12:05发表:

Him online poker free

24.10.71.* 于 2007-06-25 08:11:53发表:

As a summary of live online poker

83.209.33.* 于 2007-06-25 08:07:24发表:

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

24.10.71.* 于 2007-06-25 08:06:58发表:

Based on 888 pacific poker

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

An texas hold em poker online

72.36.192.* 于 2007-06-25 07:58:24发表:

72.36.192.* 于 2007-06-25 07:57:56发表:

72.36.192.* 于 2007-06-25 07:56:58发表:

72.36.192.* 于 2007-06-25 07:56:33发表:

72.36.192.* 于 2007-06-25 07:56:22发表:

0.0.0.* 于 2007-06-25 07:53:16发表:

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

0.0.0.* 于 2007-06-25 07:53:06发表:

payday cash advance payday cash advance http://www.rajmaai.com/_rajmaai/00000893.htm free roulette game roulette tip http://www.freewebs.com/casino-44/roulette-1.html no teletrack payday loan http://www.northpulaski.com/mysite2/_disc2/00000278.htm no teletrack payday loan same day payday loan same day payday loan http://www.ragazzinet.it/Forum/Animali/_disc1/00000193.htm play slots http://www.freewebs.com/casino-68/slots-2.html sim slots

0.0.0.* 于 2007-06-25 07:47:48发表:

As a result 888 pacific poker

0.0.0.* 于 2007-06-25 07:44:46发表:

http://www.topofmyhead.info/_discGodVoter/000021ca.htm instant payday loan instant payday loan 7 card stud http://www.freewebs.com/casino-97/card-stud-1.html 7 card stud http://thetrainingclinic.com/_disc1/000008d2.htm no credit check payday loan no credit check payday loan casino craps http://www.freewebs.com/casino-89/craps-4.html craps game free slots machine play free slots machine http://www.freewebs.com/casino-24/slots-3.html

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐