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

0.0.0.* 于 2007-06-26 23:43:19发表:

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

85.227.185.* 于 2007-06-26 16:39:06发表:

d707045a8b15ac68a57a536d20e8c1a4 http://de-cuius-incapace-intendere-prova.filgvg.org/ http://giocoyugiohscaricabile.olskny.org/utero-bicorne-20-settimana-gravidanza/ http://scrivereletterapresentazioneaddatorelavoro.swmvze.org/ef-computer-corso-milano-microsoft/ http://poesiedipasquaininglese.swmvze.org/museo-diocesano-d-arte-sacra-chiavari/ http://callofduty2prezzo.swmvze.org/legge-regionale-32-1954-sicilia/ http://testocompletonottedinvernoviaggiatore.mjdrvf.org/isvap-banca-d-italia-differenza/ http://case-in-legno-pino-artico.pidgzp.org/ http://graduatoria-master-neuropsicologia-clinica-milano.pidgzp.org/ http://contratto-collettivo-nazionale-domestici-conviventi.pidgzp.org/ http://alberghi-e-bed-and-breakfast.ozetoz.org/ ac74524788537f28ae4c90c357df5e97

77.70.106.* 于 2007-06-26 11:58:06发表:

Before texas holdem game

222.124.197.* 于 2007-06-26 11:25:54发表:

payday cash loan payday cash loan http://www.tecnoago.it/Forum/_messaggi/000005dc.htm no fax payday loan no fax payday loan http://www.nlcgwh.com/_disc3/000008d2.htm cash advance payday loan cash advance payday loan http://mchome.lincoln.ac.uk/subsite/Week4A/000000bc.htm payday loan 1000 payday loan 1000 http://www.conservatorio.brescia.it/ForumDarfo/_disc16/00000c7b.htm bad debt loan payday bad debt loan payday http://www.cours.polymtl.ca/tic/_disc1/00000035.htm

82.99.219.* 于 2007-06-26 09:16:54发表:

Overall texas hold em poker online

67.153.148.* 于 2007-06-26 09:12:20发表:

In particular online video poker

72.36.192.* 于 2007-06-26 08:55:06发表:

72.36.192.* 于 2007-06-26 08:54:48发表:

72.36.192.* 于 2007-06-26 08:53:38发表:

72.36.192.* 于 2007-06-26 08:53:18发表:

72.36.192.* 于 2007-06-26 08:53:06发表:

163.13.129.* 于 2007-06-26 08:36:46发表:

I am free poker game

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

In that case pacific poker download

165.24.252.* 于 2007-06-26 08:32:43发表:

Three online texas holdem

0.0.0.* 于 2007-06-26 08:29:44发表:

The party poker bonus code

0.0.0.* 于 2007-06-26 07:05:56发表:

bad credit payday loan bad credit payday loan http://home.nc.rr.com/marktrail/_disc1/0000009d.htm no teletrack payday loan no teletrack payday loan http://www.conservatorio.brescia.it/ForumDarfo/_disc16/00000c7c.htm craps rules craps rules http://www.freewebs.com/casino-82/craps-3.html http://www.birdbrainsolutions.com/birdbrainforum/BeakSpeak/00000079.htm payday advance loan payday advance loan free online keno free keno http://www.freewebs.com/casino-87/keno-5.html

189.19.25.* 于 2007-06-26 07:04:14发表:

http://24-7christianministries.com/_24-7Ministriesdisc1/00000063.htm no faxing payday loan no faxing payday loan video keno online keno http://www.freewebs.com/casino-89/keno-6.html free craps game how to play craps http://www.freewebs.com/casino-97/craps-2.html keno casino http://www.freewebs.com/casino-87/keno-3.html online keno http://www.freewebs.com/casino-24/blackjack-3.html online casino blackjack blackjack online

169.227.254.* 于 2007-06-26 06:31:55发表:

play blackjack online free jack black http://www.freewebs.com/casino-76/blackjack-6.html free online blackjack game online blackjack game http://www.freewebs.com/casino-66/blackjack-6.html 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 savings account payday loan savings account payday loan http://www.hawkman.org/tarot/forum/_disc1/00001c7b.htm

0.0.0.* 于 2007-06-26 06:30:56发表:

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

0.0.0.* 于 2007-06-26 06:30:03发表:

cash til payday loan http://www.btpformationeure.fr/_disc1/00000045.htm cash til payday loan fast cash payday loan http://www.mamm-mariag.it/_disc12/000000fe.htm fast cash payday loan online keno http://www.freewebs.com/casino-44/keno-3.html play keno online http://www.fourvalves.com/chat/00000072.htm cash until payday loan cash until payday loan military payday loan http://mchome.lincoln.ac.uk/subsite/Week4A/000000bb.htm military payday loan

124.46.166.* 于 2007-06-26 06:28:49发表:

68.40.152.* 于 2007-06-26 06:27:09发表:

More than one of texas hold em poker online

190.45.189.* 于 2007-06-26 06:25:01发表:

Actually party poker com

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

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

0.0.0.* 于 2007-06-26 06:00:22发表:

In other words video poker game

165.24.252.* 于 2007-06-26 05:52:32发表:

An example internet poker

0.0.0.* 于 2007-06-26 05:49:16发表:

Please free online poker

24.239.129.* 于 2007-06-26 05:49:15发表:

Just like pacific poker bonus code

24.10.71.* 于 2007-06-26 05:47:42发表:

Will online casino poker

221.170.184.* 于 2007-06-26 05:39:00发表:

I am texas holdem poker online

24.10.71.* 于 2007-06-26 04:07:42发表:

As a result pacific poker bonus code

70.164.246.* 于 2007-06-26 03:44:00发表:

Go texas holdem tournament

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

Just as free texas holdem poker game

84.21.79.* 于 2007-06-26 03:12:44发表:

The online poker rooms

66.192.6.* 于 2007-06-26 03:12:42发表:

0.0.0.* 于 2007-06-26 03:11:44发表:

online casino game casino game http://www.freewebs.com/casino-89/casino-7.html fast cash payday loan fast cash payday loan http://www.28silverstreet.com/_disc5/00001a51.htm free blackjack game free online blackjack http://www.freewebs.com/casino-78/blackjack-3.html free baccarat baccarat game http://www.freewebs.com/casino-89/baccarat-7.html http://www.voteing.info/_disc1/00001268.htm instant faxless payday loan instant faxless payday loan

0.0.0.* 于 2007-06-26 02:57:35发表:

progressive slots http://www.freewebs.com/casino-68/slots-1.html play free slots payday loan 1000 http://www.johnburrowsproject.com/_kbas/0000004b.htm payday loan 1000 http://www.freewebs.com/casino-97/keno-3.html keno casino free keno casino games http://www.freewebs.com/casino-13/casino-6.html casino games no fax payday loan no fax payday loan http://home.satx.rr.com/usedbooksiwhs/BooksForSale/0000004b.htm

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

Similarly pacific poker bonus code

203.167.76.* 于 2007-06-26 02:36:13发表:

Don't live online poker

0.0.0.* 于 2007-06-26 02:31:11发表:

Think poker games

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐