经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-20 04:36:43发表:
blogspot.com loan payday site blogspot.com loan payday site http://www.kityanpoetry.com/community/_disc7/00001123.htm payday advance loan http://fouinax.com/FEM_FORUM/000000d0.htm payday advance loan loan til payday loan til payday http://www.purperofamily.org/_disc1/00000036.htm payday loan store payday loan store http://www.vagleleiren.sandnes.no/odisk/_olopdisk/000003e4.htm payday loan payday loan http://www.mysharktank.com/discuss/_disc1/0000015c.htm
211.144.82.* 于 2007-06-20 04:20:40发表:
roulette gambling play free roulette http://www.freewebs.com/casino-53/roulette-3.html payday loan canada http://www.sflcoc.com/_sflgb/000016e6.htm payday loan canada free slots machine slots game http://www.freewebs.com/casino-76/slots-7.html 7 card stud http://www.freewebs.com/casino-78/card-stud-1.html seven card stud payday loan on line payday loan on line http://www.houselist.com/_forum4/000000b3.htm
82.47.157.* 于 2007-06-20 04:17:26发表:
http://www.ssc.com.kw/DB/_disc1/00003d5e.htm no credit check payday loan no credit check payday loan no fax payday loan no fax payday loan http://amitechnologies-inc.com/_cusudi/000003c0.htm casino baccarat casino baccarat http://www.freewebs.com/casino-13/baccarat-7.html cash til payday loan cash til payday loan http://timeforaction.org/_disc2/00000edb.htm payday loan online payday loan online http://www.aromaticsage.com/_disc10/00000781.htm
87.116.181.* 于 2007-06-20 03:53:23发表:
payday loan debt http://members.tripod.com/branhamhighforum/_disc13/00000416.htm payday loan debt http://www.freewebs.com/casino-66/keno-1.html free online keno keno online http://www.freewebs.com/casino-78/blackjack-6.html blackjack gambling online blackjack http://www.freewebs.com/casino-78/baccarat-1.html baccarat game free baccarat free casino http://www.freewebs.com/casino-44/casino-1.html free casino game
190.74.211.* 于 2007-06-20 03:35:40发表:
25b02678d8cce211f53807619dec51db http://girl-treviso-escort-best-annuncio.hzsssu.org/index.htm http://prospettiva-dei-centro-agroalimentari-2006.kculvb.org/index.htm http://appartamento-vendita-via-tasso-napoli.kculvb.org/index.htm http://puttana-troia-girl-donna-pagamento-ravenna.hzsssu.org/index.htm http://gobbo-notre-dama-antony-queen.sjfxge.org/index.htm http://foto-disegno-dragon-ball-af.qafifx.org/index.htm http://anticipazioni-soap-opera-cento-vetrine.sjfxge.org/index.htm http://inno-ufficiale-di-forza-italia.ykjmka.org/index.htm http://casa-affitto-san-giovanni-lupatoto.qafifx.org/index.htm http://tabella-calcolo-permanente-rca-frattura-dito.ihzaaf.org/index.htm a95af8f224b8c9334b8122ef4b45f39a
89.33.112.* 于 2007-06-19 23:15:10发表:
ameriloan payday loan ameriloan payday loan http://www.dswa.org.uk/dswatalk/walling/00000963.htm http://www.freewebs.com/casino-97/roulette-7.html roulette table play roulette online quik payday loan quik payday loan http://kreacom.com/_scd1/000000b3.htm online casino http://www.freewebs.com/casino-24/casino-6.html best online casino gambling http://www.rememberingheroes.org/_disc2/00001204.htm cash advance paydayloans cash advance paydayloans
0.0.0.* 于 2007-06-19 23:07:28发表:
money tree payday loan money tree payday loan http://www.pfm.com.hk/_disc4/00002c4e.htm http://www.grevemidtby.dk/Diskussion/000000c3.htm online payday loan online payday loan http://www.freewebs.com/casino-41/keno-3.html keno online online keno casino baccarat casino baccarat http://www.freewebs.com/casino-66/baccarat-2.html instant faxless payday loan instant faxless payday loan http://www.southatlantatouringgroup.com/MessageBoard/0000042d.htm
125.120.130.* 于 2007-06-19 21:34:28发表:
中文域名注册以及虚拟主机、网站建设、域名空间等互联网应用服务;国内.CN域名注册10元/年,国际域名注册65元/年。
。。
85.227.136.* 于 2007-06-19 20:24:33发表:
fax payday loan http://www.dfs-fuchsia.dk/_disc1/00004f58.htm fax payday loan http://www.vikingnewz.org/web%20discussion/001/000000ae.htm fast payday loan fast payday loan http://vip-membersfp.webc.lyceu.net/www.ez4u.se/_disc1/0000002d.htm cash advance payday loan cash advance payday loan quick payday loan quick payday loan http://www.hackwith.com/blog/_disc1/000026e4.htm no credit check payday loan no credit check payday loan http://www.duderanchontario.com/_disc1/000008ba.htm
195.222.112.* 于 2007-06-19 20:22:27发表:
http://www.freewebs.com/casino-24/slots-2.html free slots machine game slots online video keno http://www.freewebs.com/casino-45/keno-4.html internet keno free roulette http://www.freewebs.com/casino-97/roulette-2.html online roulette free online slots http://www.freewebs.com/casino-53/slots-2.html free online slots baccarat online baccarat online http://www.freewebs.com/casino-68/baccarat-5.html
222.237.5.* 于 2007-06-19 18:21:20发表:
online roulette poker roulette online http://www.freewebs.com/casino-78/roulette-6.html quik payday loan quik payday loan http://www.tidnet.com/_disc1/00003647.htm savings account payday loan savings account payday loan http://www.papillonphotos.com/_disc1/00001747.htm bad debt loan payday bad debt loan payday http://www.broncohut.com/_Trucks/00004d7a.htm http://www.freewebs.com/casino-53/blackjack-5.html play blackjack online blackjack odds
88.158.193.* 于 2007-06-19 17:16:26发表:
free keno games keno online http://www.freewebs.com/casino-78/keno-2.html baccarat online http://www.freewebs.com/casino-24/baccarat-5.html baccarat game payday loan online payday loan online http://suggeststuff.com/suggeststuff/0000004e.htm http://www.usechemicalssafely.com/_disc1/000000b1.htm blogspot.com fax loan no payday site blogspot.com fax loan no payday site payday loan online http://www.azodchat.com/freshwaterclassifieds/_disc24/0000055a.htm payday loan online
0.0.0.* 于 2007-06-19 16:29:30发表:
http://warmsector.com/_storm_forum/0000009c.htm fast cash payday loan fast cash payday loan payday loan canada payday loan canada http://www.alicevroberts.com/Discussion1/0000032e.htm http://www.freewebs.com/casino-68/keno-1.html play keno online play keno online http://www.lo-ung.com/_disc6/00000537.htm loan til payday loan til payday http://www.irishsetterclub.org/_Katrina_Disc/00000035.htm payday loan canada payday loan canada
0.0.0.* 于 2007-06-19 16:17:41发表:
http://www.freewebs.com/casino-66/roulette-5.html online roulette game free roulette instant faxless payday loan instant faxless payday loan http://othbasketball.org/_disc1/00000095.htm http://www.hurricanerunners.net/_disc1/00000096.htm fast cash payday loan fast cash payday loan payday loan personal payday loan personal http://www.citizensmatrix.com/_disc1/000000e7.htm free baccarat baccarat online http://www.freewebs.com/casino-82/baccarat-4.html
66.65.31.* 于 2007-06-19 14:36:30发表:
baccarat online play baccarat http://www.freewebs.com/casino-97/baccarat-4.html http://www.blenusmodels.com/_disc1/000004e3.htm payday loan company payday loan company seven card stud 7 card stud http://www.freewebs.com/casino-44/card-stud-3.html money tree payday loan money tree payday loan http://www.weddingwebsonline.com/goodman/guestbook/_disc17/00000207.htm http://www.scagliotti.net/_disc1/000019eb.htm ameriloan payday loan ameriloan payday loan
0.0.0.* 于 2007-06-19 13:59:45发表:
easy payday loan http://www.superslamcountdown.com/_Hunting_Alaska/0000004b.htm easy payday loan cheap payday loan cheap payday loan http://www.dgfoutdoors.com/_disc1/00000258.htm http://www.labarbabietola.it/forum/forum/000009f5.htm payday advance loan payday advance loan 7 card stud 7 card stud http://www.freewebs.com/casino-82/card-stud-4.html free online baccarat baccarat game http://www.freewebs.com/casino-66/baccarat-1.html
0.0.0.* 于 2007-06-19 13:57:05发表:
http://www.freewebs.com/casino-97/blackjack-6.html jack black jack black no fax payday loan http://www.alessiamore.it/file%20nascosti/_disc10/00000256.htm no fax payday loan free online blackjack game blackjack odds http://www.freewebs.com/casino-44/blackjack-6.html http://tuvc.com/tech/_disc11/00000044.htm cheap payday loan cheap payday loan http://www.freewebs.com/casino-97/blackjack-5.html play blackjack online free jack black
0.0.0.* 于 2007-06-19 13:49:38发表:
payday loan online payday loan online http://www.rochesterceliacs.org/_forum/000041e9.htm
72.36.192.* 于 2007-06-19 08:25:31发表:
Nice site!
free ringtones for verizon | free ringtones for lg | free verizon ringtones | free sprint pcs ringtones | polyphonic ringtone | nokia free downloads | mp3 ringtones | suncom ringtones | voice ringtone | free mp3 ringtones download
72.36.192.* 于 2007-06-19 08:25:04发表:
Thank you!
free samsung ringtones | free ringtone downloads | free cellular south ringtones | free real music ringtones | cricket free ringtones | free cellular ringtones | mp3 ringtone converter | free nokia ringtone | free real ringtones for cingular | 24 ringtone free
72.36.192.* 于 2007-06-19 08:24:00发表:
Good design!
christian ringtones | free cingular ringtones | ringtone creator | mosquito ring tone | free cingular cell phone ringtones | free ringtones for t-mobile | mp3 ringtones download | free star wars ringtones | download free motorola ringtone | free nascar ringtones
72.36.192.* 于 2007-06-19 08:23:41发表:
Nice site!
polyphonic ringtones | free motorola ringtones | free downloadable t mobile ringtones | free motorola downloads | mosquito ringtone | razr v3 ringtones | ringtones for alltel | download free ringtones | 24 ring tones | free ringtones us cellular
72.36.192.* 于 2007-06-19 08:23:26发表:
Thank you!
alltel free ringtones | midi ringtone | boost mobile ringtones | arabic ringtones | ringtones wav | anime ringtones | tmobile ringtones | free midi ringtone | mobile ringtones | nascar ringtones
201.235.34.* 于 2007-06-19 02:16:17发表:
f82d30b9fd8472db369db06c8ead6372 http://piatto-tradizionale-dell-abruzzo-solo-abruzzo.fyeclo.org/index.htm http://esempio-questionario-progetto-alunni-scuola.tadctp.org/index.htm http://scheda-pci-wireless-54-mbps.giqjae.org/index.htm http://dragon-ball-z-immagine-dei-sayan.bqltxq.org/index.htm http://video-integrale-dell-esecuzione-saddam-censura.xfjpsj.org/index.htm http://foto-concerto-iron-maiden-milano.fyeclo.org/index.htm http://pinco-pallino-sfilata-estate-2006.vooxwa.org/index.htm http://lombardia-legge-regionale-n-18.nudmpy.org/index.htm http://prestito-d-onore-donna-sicilia.vooxwa.org/index.htm http://berlusconi-prodi-chi-ha-vinto.ugbiie.org/index.htm b8055c662679464e43a32265312932f9
72.36.192.* 于 2007-06-18 08:32:25发表:
Nice site!
gambling casino online | internet gambling casinos | dice and card games | jackpot casino | play for fun casinos on mac | best casino bonuses | free poker no downloads | monopoly slot games | best internet casinos | quality casinos online
72.36.192.* 于 2007-06-18 08:31:47发表:
Nice site!
play free keno | free no deposit online casino bonuses | planet poker | online poker room reviews | free video poker games that pay real money | download texas holdem | caribbean poker | fee hoyle casino games | offshore gambling | draw poker electronic handheld game
72.36.192.* 于 2007-06-18 08:30:57发表:
Well done!
free online casino slots | play bingo for kids online | video keno downloads | network blackjack | online casino and sports betting | poker online forreal money | play price is right casino game free | free online video poker jacks or better for prizes | casino slot games message boards | online gaming sites
72.36.192.* 于 2007-06-18 08:30:40发表:
Great work!
freeroll poker websites | world poker | play free texas hold em poker | free triple bonanza slot machine games | casino slots no download | poker sets | free websites to play bingo | casino best offers | bingo with free sign up bonus no deposit | free pocket pc casino games
72.36.192.* 于 2007-06-18 08:30:28发表:
Great work!
casino online uk | download free poker game | free casino download | casino listings uk | totally free video keno software downloads | blackjack 21 | blackjack free game | free online casino slots to play no download | flash casino free games slots | online gambling casino sites
62.42.120.* 于 2007-06-18 01:24:03发表:
fbcadc036ff1bc7e58d363e7ff31257a http://lievito-di-birra-per-cavalli.mmaiuw.org/index.htm http://trucco-pirata-dei-caraibi-pc.esqhid.org/index.htm http://l-ufficio-del-registro-di-como.glzaqv.org/index.htm http://maglione-polo-ralph-lauren-lana-merinos.ovnfxu.org/index.htm http://collaborazione-cover-2006-gloria-estefan.mmaiuw.org/index.htm http://campagna-vaccinazione-antinfluenzale-2006-2007.zpympv.org/index.htm http://case-in-affitto-salsomaggiore-terme.mmaiuw.org/index.htm http://concorso-educatrice-asilo-nido-piemonte.ogttfu.org/index.htm http://mi-hai-rapito-il-cuore-lam.lwfhrb.org/index.htm http://topolino-fa-sesso-minnie-internet.ogttfu.org/index.htm b3e1aeebf15010c0e48986d09609c4eb
81.183.197.* 于 2007-06-17 00:06:41发表:
ff5e1b5f2186f3ac745d661b0993e8ae http://famiglia-testimone-speranza-momento-preghiera.rvumsf.org/index.htm http://cassa-acustiche-pc-2-1.zfdyqr.org/index.htm http://foto-gratis-di-giovani-troia.yssvot.org/index.htm http://faccio-scaricare-java-rokr-e1.zfdyqr.org/index.htm http://archivio-di-stato-di-udine.ixzutk.org/index.htm http://colonna-sonora-di-hollywood-homicide.rvumsf.org/index.htm http://torno-casa-nonno-mamma-rapporto.odqknd.org/index.htm http://vendita-villa-mare-stile-rustico-toscano.ixzutk.org/index.htm http://ordine-assistenti-sociali-emilia-romagna.rvumsf.org/index.htm http://si-scrive-lettera-al-sindaco.rvumsf.org/index.htm 6a4e71b09dc8ba3b61a05d0dd09e915b
72.36.192.* 于 2007-06-16 08:24:45发表:
Thank you!
live poker online | casino games | aussie video slots | best roulette gambling | free poker web sites | roulette | online poker casino | wheel of fortune slot software download | ic money slots on line | wizard system free slots for fun
72.36.192.* 于 2007-06-16 08:23:57发表:
Great work!
best casino bonus online | casino online odd slots | poker free roll | no deposit casino bonus | casino games for fun only | free moneyslots no deposit | play black jack free | jackpot party slot machine for fun | video poker odds | virtual gambling
72.36.192.* 于 2007-06-16 08:23:19发表:
Great work!
games casino | play dice game | free online bingogames | great roulette casinos | black jack games download | internet poker web sites | slot machines play just for fun | casino gambling | online texas holdem game | newest no deposit online casino bonus
72.36.192.* 于 2007-06-16 08:23:02发表:
Good design!
free blackjack download software | casino magic casino | free christmas bingo games | casino games online | casino casino casino gambling internet online | single player draw poker | let it ride poker play for fun | network blackjack | jackpot bingo | online casino slot machines
72.36.192.* 于 2007-06-16 08:22:51发表:
Thank you!
the best online casinos | jackpot city | play for fun jumbo card video poker | twilight zone video slot game | no deposit online casinos | free poker game downloads for offline play | best online poker rooms | free money casinos | casino website | online pogo bingo
89.156.51.* 于 2007-06-15 22:59:36发表:
c79efab6285223f878edf1cd3288bb12 http://conca-d-oro-locale-brescia.qtoruw.org/ http://creare-account-windows-live-messenger.dgrbxq.org/ http://norton-internet-security-2006-codice-attivazione.asxhjv.org/ http://apparecchio-elettromedicale-ipertermia-vendita-roma.kluoca.org/ http://amore-eterno-finche-dura-verdone.asxhjv.org/ http://salone-studente-2006-ente-fiera-piacenza.kluoca.org/ http://circolo-falcone-borsellino-lega-ambiente.asytgp.org/ http://merengue-simili-vaca-sa-sa-sa.uvosok.org/ http://modifica-javascript-windows-media-player.qtoruw.org/ http://sapere-dove-andare-sesso-occasionale-sicilia.dkoomz.org/ 017184126313b130655c75e326e14932
72.36.192.* 于 2007-06-15 08:29:34发表:
Thank you!
play online casino | play slots for fun not for real money | web video poker | free casino games online | largest online gambling site | poker online no download | gambling site | online poker paypal | 3 card poker online | play party poker for fun
72.36.192.* 于 2007-06-15 08:29:05发表:
Nice site!
black jack software | making a living playing online poker | absolute poker download | ceasers free video bonus poker downloads | online poker for mac | full version online blackjack elf | place bets casino | play for fun bingo games | bingo bonus slots | play omaha poker online
72.36.192.* 于 2007-06-15 08:27:58发表:
Great work!
free play bingo | play free slots online | casino casino casino gambling internet online | free cash bingo games online | 3 card pokerfor play money | bunny poker | free bonus screen online slots | free sign up poker money | texas holdem poker play money | play free casino games