经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-05-15 07:41:53发表:
Nice site!
free bingo online | casino games | sims slots | play blackjack free | free online texas holdem | live poker | no download free slots | empire poker | play money poker | texas poker
72.36.192.* 于 2007-05-15 07:41:21发表:
Nice site!
free slots | keno online | no deposit bonus | online poker free | free roulette online | free internet poker | new online casinos | no download casino | download blackjack | online games
125.120.139.* 于 2007-05-15 00:31:00发表:
钢管信息网是国内专业激光雕刻机..刻字机...锅炉...手套
221.245.118.* 于 2007-05-14 22:56:29发表:
40d4c3a25f2358db4511a6a5d9a6707c http://comune-di-roma-fascia-verde.nvdset.com/ http://amici-di-maria-de-filippi-finale.nvdset.com/ http://tabella-valore-costo-produzione-edilizia-convenzionata.xjpled.co.in/ http://il-mercato-immobiliare-in-italia.nvdset.name/ http://riduzione-capitale-cessazione-collegio-sindacale.nvdset.com/ http://si-arriva-al-pala-tenda-brescia.nvdset.net/ http://trattato-pace-10-febbraio-1947.xjpled.biz/ http://aerocool-aeroengine-gamer-casa-jr.nvdset.biz/ http://agriturismo-la-ca-dell-alpe.xjpled.biz/ http://google-it-casa-editrice-tecnica-nuova.nvdset.com/ 8115d97afce6272748d3203e407b2c31
216.197.234.* 于 2007-05-14 11:34:41发表:
b5b383a8f19e040599e16122eb225b51 http://analisi-costi-benefici-di-un-progetto.ujttwc.com/ http://come-si-cura-la-candida.ujttwc.net/ http://larica-virtual-soc-uniurb-it-moodle.ujttwc.biz/ http://oroscopo-di-oggi-della-vergine.ujttwc.name/ http://arredamento-mobili-indonesiani-importazione-mobili.ujttwc.net/ http://cartoni-dello-zecchino-d-oro.klkhba.co.in/ http://codici-ufficio-locali-agenzia-entrata.ujttwc.name/ http://morellato-bracciale-ciondolo-cuore-stella.klkhba.biz/ http://vedere-foto-anna-tatangelo-it.ujttwc.net/ http://mia-ex-ragazza-foto-nuda.ujttwc.biz/ b0aa8b27a8ec12b02be4055d7baf88c7
125.120.139.* 于 2007-05-14 11:27:49发表:
注册香港公司专业服务，包括注册香港公司价格咨询，注册香港公司知识，注册香港公司的优势及发展，有需要注册香港公司的欢迎和我们联系。
...
杭州二手房...
三亚...
石膏粉...
condensing unit...
门禁机...
门禁系统...
风叶...
剪板机...
黄山...
标志设计...
72.36.192.* 于 2007-05-14 01:42:54发表:
Well done!
online poker free | free texas hold em online | online roulette free | play money poker | play slots for fun | poker for free | free monopoly online | casino download | gambling sites | best online casinos
72.36.192.* 于 2007-05-14 01:42:21发表:
Thank you!
no deposit online casinos | free online slots games | texas hold em poker | strip blackjack game | russian roulette game | black jack | blackjack download | slim slots free | online slot games | free sim slots
72.36.192.* 于 2007-05-14 01:41:49发表:
Well done!
free online slots no download | bonus poker | monopoly online | usa online casino | play free roulette | texas hold em | slot machine | free slot machine game | online poker | free online slots no downloads
72.36.192.* 于 2007-05-14 01:41:29发表:
Thank you!
internet blackjack | free casino bonus | download poker game | free black jack | black jack download | slot machine game | casinos online | texas hold em online | online baccarat | no deposit bonuses
72.36.192.* 于 2007-05-14 01:41:00发表:
Thank you!
poker machines | free slot machines games | gambling online | casino game download | casino free | full tilt poker | video poker | free slots no downloads | fun slots | free poker software
200.84.254.* 于 2007-05-13 22:45:53发表:
abc811779ff1abe0d80ea3cdad6bf9d0 http://art-5-legge-102-2006.ctvbxm.biz/ http://nudi-femminili-d-e-pca.ctvbxm.net/ http://miglia-tvmini-con-eyetv-20-dtt.ctvbxm.name/ http://volo-low-cost-palermo-roma.ctvbxm.name/ http://dragon-ball-z-eroe-pianeta-conuts.obuvie.name/ http://tubo-plastica-pvc-spirale-acciaio.ctvbxm.net/ http://smagliatura-and-rimedio-and-naturale.ctvbxm.biz/ http://indice-dei-libri-del-mese.obuvie.co.in/ http://tesi-difesa-suolo-sistema-sicurezza-territoriale.ctvbxm.name/ http://i-giochi-dei-nostri-nonni.obuvie.name/ a647f0935ac9b246ffd2471206f1cc7e
201.243.189.* 于 2007-05-13 10:33:27发表:
c7e4ec942cb425498c9b1a2aaf6adc3e http://uomo-nudo-gay-nudo-militare-nudo.ujttwc.net/ http://ente-nazionale-italiano-di-unificazione.ujttwc.biz/ http://s-casciano-val-pesa-comune.ujttwc.biz/ http://search-www-traghetto-info-nbci.klkhba.name/ http://patto-territoriale-per-l-occupazione.ujttwc.biz/ http://istituto-d-arte-roma-1.klkhba.co.in/ http://libretto-uso-e-manutenzione-audi-a3.ujttwc.biz/ http://clip-art-lavori-in-corso.ujttwc.biz/ http://liceo-scientifico-russell-di-milano.klkhba.biz/ http://software-gestione-agenda-anagrafica-free.klkhba.biz/ 784faf42bbc6bc8e3eef9ef627ced6bc
72.36.192.* 于 2007-05-12 21:09:31发表:
Thank you!
games download | free online blackjack | roulette games | free poker games online | poker software | texas hold em | cleopatra slots | free monopoly slots | usa online casino | best poker sites
72.36.192.* 于 2007-05-12 21:08:57发表:
Great work!
free no deposit casino | poker online free | free slot machines | black jack game | stud poker | texas hold em online | keno online | free slots on line | free poker game download | free online poker games
72.36.192.* 于 2007-05-12 21:08:07发表:
Thank you!
no deposit bonus | free poker | free slot games no download | play free blackjack online | free online slot games | black jack strip | poker sites | download slots | russian roulette | caribbean poker
72.36.192.* 于 2007-05-12 21:07:46发表:
Thank you!
free blackjack game | game slot | texas holdem | free strip black jack | play free roulette | casino deposit bonus | free casinos | free casino online | free bingo | poker machines
72.36.192.* 于 2007-05-12 21:07:13发表:
Well done!
free slots game | free texas holdem online | free no deposit casinos | play poker online | free online slots no download | live poker | poker bonus | slot machines | poker star | strip blackjack games
84.122.214.* 于 2007-05-12 18:45:04发表:
d8d46364a58d4abe0f894fd9aec370d9 http://foto-giuramento-2006-ascoli-piceno.fzjkno.net/ http://vagina-site-sanihelp-msn-it.uqqaqa.info/ http://alfa-gt-1-8-gpl.sjuvcf.net/ http://comunicato-stampa-nuova-mercedes-classe-s.unhbej.info/ http://viaggio-aereo-basso-costo-mar-rosso.fzjkno.net/ http://elenco-canzone-1999-al-2006.tpuskc.info/ http://fondo-ministero-dell-economia-finanza-argentina.jnonib.net/ http://cosa-fare-febbre-bambino-alta.sjuvcf.info/ http://ottica-occhiale-vista-dolce-gabbana.rfqhyn.net/ http://yes-know-my-way-testo.sjuvcf.info/ d9a31e90dfa815b241581cfa56f7d9b0
80.37.153.* 于 2007-05-12 04:16:19发表:
f662501fed5429438e2ab0a79788765e http://corso-ricerca-clinica-piemonte-2007.jiqgyr.net/ http://aggiornamento-di-windows-media-player.uwvdff.net/ http://mobile-bull-corte-luigi-xiv.wpktse.info/ http://ragazza-giovane-fanno-pompa-hentai.lvrsgc.net/ http://ruolo-dell-unione-europea-economia.jiqgyr.net/ http://penale-omissione-clausola-non-trasferibile.wpktse.info/ http://la-vita-e-bella-recensione.wpktse.info/ http://crociera-ultimo-dell-anno-single.wxkbfx.info/ http://24-sole-24-ora-com-fc.unhbej.net/ http://esercizio-limite-funzione-due-variabili.wsgcxb.info/ e851160535cf163ca98e2cabd77393d9
72.36.192.* 于 2007-05-11 05:34:29发表:
Good design!
cricket ringtones | free cellular south ringtones | free real music ringtones | free ringtones for t-mobile | star wars ringtones | voice ringtones | free monophonic ringtones | mosquito ring tone | 24 ctu ringtone verizon | free real ringtones
72.36.192.* 于 2007-05-11 05:33:59发表:
Thank you!
download free ringtone | hindi ringtone | nextel ringtone | ringtones verizon | free mp3 ringtone download | free ringtone | free ringtones mp3 | free polyphonic ringtones | free cell phone ring tones | ringtones composer
72.36.192.* 于 2007-05-11 05:33:16发表:
Well done!
wav ringtones | keypress ringtones | free phone ringtones | midi ringtone | verizon ctu ringtone | polyphonic ringtone | free cellphone ringtones | alltel ringtones | free anime ringtones | sprint phones
72.36.192.* 于 2007-05-11 05:32:54发表:
Great work!
christian music ringtones | centennial wireless ringtones | alltel free ringtones | free suncom ringtones | free mobile ringtones | free harry potter ringtones | ringtones | free country music ringtones | free sms ringtones | harry potter ringtones
72.36.192.* 于 2007-05-11 05:32:24发表:
Good design!
free ringtones download | motorola ringtones | ringtones for tracfone | nokia download | ringtone nokia | free ringtones for cingular | free ringtones for t mobile | free sprint downloads | motorola mp3 | free ringtones for nokia
201.235.107.* 于 2007-05-10 14:37:43发表:
179a170c1da199b7de208b78ddfe0757 http://fato-metelli-romae-fiunt-consules.cbcmld.net/ http://bando-libere-professione-femminile-lombardia.cbcmld.net/ http://hotel-neve-benessere-alto-adige.fzjkno.net/ http://accessorio-kenwood-chef-major-km005.rfqhyn.net/ http://sito-foto-amatoriale-sex-gratis.uaaxsj.info/ http://spartito-pianoforte-stairway-to-heaven.uqqaqa.info/ http://diploma-operatore-dei-servizio-sociale.tpuskc.info/ http://metodo-di-analisi-dell-acqua.rfqhyn.net/ http://partnership-s-r-via-borgo-gallarate.sjuvcf.net/ http://premio-nobel-pace-2006-discorso-yunus.sjuvcf.info/ 6ea61d011241fc97c6cd95e85f270196
72.36.192.* 于 2007-05-10 08:07:14发表:
Great work!
gambling games | slot machines | free sim slots | free online poker | play texas hold em | holdem poker | casino free game online | slot machine software | flash casino games | monopoly online
72.36.192.* 于 2007-05-10 08:06:40发表:
Nice site!
planet poker | free slots no downloads | play slots for fun | play texas holdem | poker star | casino online download | free bonus slots | video poker download | free roulette | free slots no download
72.36.192.* 于 2007-05-10 08:06:01发表:
Great work!
free games on line | caribbean stud poker | no deposit casinos | black jack strip | texas hold em online | free texas holdem poker | free roulette games | download blackjack | video slot games | best bonus casino
72.36.192.* 于 2007-05-10 08:05:52发表:
Great work!
free casino money | blackjack strip | free video slots | casino bonus | blackjack free | roulette download | online poker game | free money casinos | blackjack online | poker free download
72.36.192.* 于 2007-05-10 08:05:10发表:
Good design!
free play slot machines | poker for free | no download slots | casino slots | sims free slots | online poker | casino no deposit | online casinos | free slot machine games online | online black jack
72.36.192.* 于 2007-05-09 06:59:41发表:
Nice site!
free multi line slots | free online casino game | casino free game online | free casino game | free video slots | free video | download free poker games | black jack game | computer poker | free slots games
72.36.192.* 于 2007-05-09 06:59:16发表:
Nice site!
poker stars download | free slot games no download | no deposit bonus casinos | online gambling | poker free download | poker game | online baccarat | play blackjack | no deposit casino | free slot machines
72.36.192.* 于 2007-05-09 06:58:37发表:
Great work!
flash casino games | free roulette games | free blackjack | casino poker | cleopatra slots | bingo games | online bingo | free casino downloads | free texas hold em | slot machine game
72.36.192.* 于 2007-05-09 06:58:14发表:
Great work!
poker for free | blackjack free games | paradise poker | slot games | texas holdem free | free online blackjack | free slots on line | sims slots | no deposit online casino | free poker
72.36.192.* 于 2007-05-09 06:57:46发表:
Nice site!
free texas hold em | slot machine | download free poker game | poker games download | black jack games | free on line slots | play casino games | free no download slots | download casino games | russian roulette game
62.195.56.* 于 2007-05-09 04:47:45发表:
ad1ae07e6c4b0acb815ef6dbab3aff2b http://a-se-stesso-leopardi-commento.avborz.info/ http://modello-ricorso-giudice-pace-autovelox.avborz.info/ http://giochi-di-matematica-per-bambini.qncqss.net/ http://scaricare-suoneria-loghi-tutti-nokia.fneces.net/ http://scarica-video-because-you-live.wpktse.net/ http://costruire-le-porte-in-legno.esitxq.info/ http://convertitore-formato-avi-in-mpeg.tpuskc.net/ http://samsung-sgh-z400-suoneria-sms.qncqss.net/ http://giorgia-dire-fare-terra-mare.vuulyy.net/ http://parrucchiera-mina-quartu-sant-elena.wpktse.net/ c30356c496a34fc36d31054e2275bbe2
84.121.108.* 于 2007-05-08 18:10:38发表:
2ddb4490bc38279ea42f37ad46849ee2 http://luna-rossa-disco-bosco-marengo.uyabmw.net/ http://poesia-natale-bambino-scuola-dell-infanzia.uaaxsj.net/ http://punto-187-telecom-italia-guidonia-montecelio.lvrsgc.info/ http://ritenuta-d-acconto-su-firr.vsytef.net/ http://azione-diretta-neo-confronti-responsabile-civile.jnonib.info/ http://lettera-al-sindaco-smaltimento-rifiuto.vsytef.net/ http://un-tuffo-dove-l-acqua.kpcmsw.info/ http://bianca-neve-sette-nano-astuccio.lvrsgc.info/ http://legge-regionale-n-142-2006.vkzzwe.net/ http://progetto-secondo-modello-sfondo-integratore.nxlnkr.info/ ad9883469ac620e72a2c30c2417cb4d3
72.36.192.* 于 2007-05-08 07:21:08发表:
Well done!
sprint free ringtones | ringtone 24 ctu | ringtones wav | motorola ringtones free | free ringtones alltel | free ringtones for tracfones | free cingular ringtones | free t mobile ringtones | ringtones midi | free 24 ringtone
72.36.192.* 于 2007-05-08 07:20:36发表:
Good design!
free hi fi ringtones | free boost mobile ringtones | nokia free ringtones | mp3 ringtones free | christian ringtones | free motorola ringtone downloads | free sanyo ringtones | monophonic ringtones | lg free ringtones | star wars ringtone