经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.211.* 于 2007-07-18 21:14:13发表:
Thank you!
free poker downloads | free monopoly online | on line poker | free online strip blackjack | free texas holdem online | casino bonus | strip blackjack free | poker sites | no deposit bonus casinos | casino game
72.36.211.* 于 2007-07-18 21:13:11发表:
Thank you!
free poker | online poker game | slot machine | free play slot machines | online video slots | online slots | poker free download | casino bonuses | casino open usa | free joker poker
72.36.211.* 于 2007-07-18 21:12:47发表:
Great work!
slot machine | no deposit casinos | online free roulette | poker stars download | slot games | free online slots no downloads | no deposit casino bonus | blackjack free | play free slots | games online
72.36.211.* 于 2007-07-18 21:12:34发表:
Nice site!
texas holdem | video slot machine | best usa casino online | play black jack | play money poker | free bonus slots | pokerstars download | free poker games | online poker free | free on line slots
125.120.132.* 于 2007-07-17 21:49:32发表:
72.36.211.* 于 2007-07-17 21:00:00发表:
Good design!
tapety zdarma | free phone downloads | composer ringtones | motorola razr v3 ringtones | free midi ringtones | free ringtone converter | logos para movil | cellular south ringtones | samsung free ringtones | ringtones free
72.36.211.* 于 2007-07-17 20:59:06发表:
Well done!
kyocera ringtones | free sprint downloads | handy klingelton | bedava cep melodi | razr ringtones | ingyen sms | free monophonic ringtones | alltel free ringtones | nokia downloads | ctu ring tone
72.36.211.* 于 2007-07-17 20:58:47发表:
Great work!
mp3 ringtone | 24 ring tones | free ringtones for boost mobile | sonneries gratuites | ringtones motorola | free ringtones for lg | centennial wireless | christian music ringtones | ringtones for verizon | free lg ringtones
72.36.211.* 于 2007-07-17 20:58:35发表:
Thank you!
suonerie polifoniche | cricket ringtones | free mp3 download | cep melodi | logo sonnerie | keypress ringtones | free hi fi ringtones | wav ringtones | anime ringtones | free ringtones for t-mobile
84.126.57.* 于 2007-07-17 18:54:15发表:
11c95cff7a1eef349c3c47d74964bdb4 http://programmaperscaricarefotodigitale.wfdklb.org/tinte-per-capelli-l-oreal/ http://grossistapietradure.lgyeas.org/giochi-online-sesso/ http://pubblitalia80.eebsig.org/ultras-bari/ http://fedipolello.vniybd.org/link-http-blabla-sonia-blogspot/ http://scaricagratisspybotsearchdestroy.eebsig.org/entrare-giardino-poesia-giacomo-leopardi-testo/ http://ginnasticapsicomotoria.wfdklb.org/web-design-agrate-brianza/ http://batteriaservizio.ppnxyq.org/sigla-tg-5/ http://raffaellaamato.qbmkwd.org/affidamento-servizio-gas/ http://wwfipavpallavolounder16campionato.lgyeas.org/videogiochi-recensioni/ http://casasrlrete.jpwypc.org/mostarda-di-frutta/ 8ea4fcdde1a965ef95e68187f350c6f6
221.147.252.* 于 2007-07-17 11:01:44发表:
http://21cc03219bd2fcb3d783d9598588fe63-t.xkktxb.org 21cc03219bd2fcb3d783d9598588fe63 http://21cc03219bd2fcb3d783d9598588fe63-b1.xkktxb.org 21cc03219bd2fcb3d783d9598588fe63 http://21cc03219bd2fcb3d783d9598588fe63-b3.xkktxb.org 8d1f2bfe3cbc5359328d95464cab8b7c
72.36.211.* 于 2007-07-16 21:25:10发表:
Great work!
russian roulette games | slot machine games | free online blackjack | blackjack for free | texas holdem | free slots | slots games | casino online download | free slots on line | download casino
72.36.211.* 于 2007-07-16 21:24:39发表:
Well done!
deposit bonus casino | online slot games | russian roulette | download poker game | blackjack games | world poker | free online casino game | poker game free | online bingo games | poker game
72.36.211.* 于 2007-07-16 21:23:40发表:
Good design!
free bingo | games slots | three card poker | free online gambling | play roulette for free | slot machine game | roulette online | free online black jack | poker texas holdem | new no deposit casinos
72.36.211.* 于 2007-07-16 21:23:18发表:
Well done!
play texas hold em | free fun slots | empire poker | free online games | computer poker | free video slots | free poker sites | play blackjack free | poker for fun | free games on line
72.36.211.* 于 2007-07-16 21:23:09发表:
Thank you!
video slots free | full tilt poker | black jack game | poker on line | slot machines games | poker sites | on line poker | slots for fun | slot machine software | monopoly slot machine
201.213.48.* 于 2007-07-16 10:02:39发表:
451b3287cdd82411a3c8e3b7736a53a6 http://annuncio-economico-lecce.mxkrxs.com/ http://annuncio-x-incontro.xmjviq.com/ http://cimitero-animale-affezione.xsixxz.biz/ http://aparthotel-plaza-de-spagna.ynpojb.biz/ http://fornitori-asl.xsixxz.biz/ http://armata-rossa-mp3.fuypfr.biz/ http://stato-famiglia-residenza.ynpojb.biz/ http://creazione-lettera-stampa-unione.drncar.biz/ http://video-porno-gratis-di-porno-star.xxmndb.biz/ http://camping-ratisbona.gvjcaf.com/ 8cff813cd5cdf93d908a9e43c4704dad
72.36.211.* 于 2007-07-15 23:45:07发表:
Nice site!
noble poker | casino free game online | slot machines games | free slot game | free strip black jack | free casino | texas hold em online | free sim slots | poker for fun | stud poker
72.36.211.* 于 2007-07-15 23:44:38发表:
Well done!
poker games | gambling games | video poker free | blackjack online | blackjack games | black jack game | new online casinos | new casinos | free blackjack games | free online gambling
72.36.211.* 于 2007-07-15 23:43:35发表:
Well done!
free online casino | free online texas holdem | free video slot games | fun slots | free bingo online | pacific poker | free online slots | poker game | no deposit bonus | online bingo games
72.36.211.* 于 2007-07-15 23:43:15发表:
Nice site!
monopoly slot machine | free black jack | free slot machine play | free video | absolute poker | online casino bonus | roulette download | free texas hold em | online texas hold em | casino online download
72.36.211.* 于 2007-07-15 23:43:01发表:
Great work!
online strip blackjack | download poker game | poker for free | free blackjack | free slots on line | play free slots | play money poker | free casino online | casino slots | bonus poker
85.136.160.* 于 2007-07-15 02:14:47发表:
761922521c58e13a1b07dfe0bb84ec93 http://simonamonetti.kqjhpm.org/autoradio-alpino-cda/ http://dispensaattoamministrativo.mongnb.org/stoccaggio-gas/ http://dolcealmelograno.jlmwbv.org/ristorante-teatro-bergamo/ http://linusmandria.gapphu.org/maschera-snowboard-smith-fuse/ http://migliorarespirazionecellulare.vozulo.org/aziende-grosseto/ http://eleonoraruffo.eqacfr.org/cioffi-gabriele/ http://azionitelecom.seklde.org/piano-emergenza-comunale/ http://ravepartybolognacapodanno.jlmwbv.org/prezzo-filtro-aria/ http://sorciopaoloit.mqyawz.org/fax-telecom-prezzo/ http://campoesperienzacenerentola.gapphu.org/lavori-stazione-tiburtina/ a875aa102e91579b074fe29fa7a13e81
72.36.192.* 于 2007-07-14 07:06:52发表:
Good design!
mobil telefon | free ringtones for sprint | suonerie cellulare gratis | 24 ctu ringtone verizon | bedava polifonik melodi | download free ringtones | toques gratuitos | country ringtones | darmowe dzwonki | ringtones midi
72.36.192.* 于 2007-07-14 07:06:26发表:
Great work!
free real music ringtones | 24 ringtones | absolutely free ringtones | free ring tones | 24 ctu ringtones | free cricket ringtones | samsung melodi | cisco ringtones | mp3 ringtones download | mobile phone ringtones
72.36.192.* 于 2007-07-14 07:05:19发表:
Good design!
ringtone composer | free us cellular ringtones | ringtone motorola | melodie zdarma | sonneries mobile | mp3 ringtones | mobiel ringtone | real music ringtones | boost ringtones | verizon ctu ringtone
72.36.192.* 于 2007-07-14 07:05:01发表:
Great work!
motorola keypress ringtones | suonerie polifoniche samsung | free sprint pcs ringtones | gratis klingelton | tmobile free ringtones | sonnerie sagem | free ctu ringtone | mp3 klingelton | free ringtones sprint | mp3 ringtone download
72.36.192.* 于 2007-07-14 07:04:49发表:
Well done!
downloadable ringtones | free wav ringtones | free ringtones for nextel | suonerie per cellulari | tracfone ringtones | ringtone websites | free nextel ringtones | free real ringtones for cingular | toques reais | free ringtone
121.178.171.* 于 2007-07-13 19:01:09发表:
8056bc5ae5ef608de0d296b526b5b59d http://sesso-matura.mhjqva.org/ http://trattamento-dimagrante.benlzg.org/ http://legname-rovere.tttfhp.org/ http://idromassaggio-esterno-firenze.iwfpha.org/ http://concorsi-guida.aoonyx.org/ http://telecom-rimborso-canone.njylwy.org/ http://tariffa-escort-bologna.wuzzme.org/ http://boldrini-ines.ubetii.org/ http://catering-per-matrimonio-toscana.tttfhp.org/ http://software-foto-e-calendario.aoonyx.org/ 8c2a5fabd273020cebfaea52010ee4bb
72.36.192.* 于 2007-07-13 07:34:22发表:
Well done!
free christian ringtones | free ringtones for samsung | free ringtones for t-mobile | free hifi ringtones | mobiele ringtones | tmobile free ringtones | free 24 ctu ringtone | boost ringtones | free ringtones sprint | gratis mobilspel
72.36.192.* 于 2007-07-13 07:33:58发表:
Thank you!
free ringtones cingular | mobil hry | free cingular real ring tone | free centennial wireless ringtones | centennial ringtones | free cellular south ringtones | mp3 ringtone | arabic ringtones | mp3 ringtones free | sprint ringtones
72.36.192.* 于 2007-07-13 07:32:46发表:
Well done!
free country ringtones | ringtone free | suonerie per cellulari | free polyphonic ringtone download | mp3 ringtones download | ctu ringtones | free 24 ringtones | hindi ringtone | bedava polifonik melodi | downloaden ringtones
72.36.192.* 于 2007-07-13 07:32:27发表:
Good design!
free anime | klingelton download | dzwonki do nokii | sanyo ringtones | toques telemoveis | free star wars ringtones | cricket free ringtones | tapety zdarma | motorola q ringtones | ringtones composer
72.36.192.* 于 2007-07-13 07:32:14发表:
Great work!
handy klingelton | free ringtones us cellular | sms ringtones | dzwonek mp3 | ringtones | ringtones motorola | free wav ringtones | bedava cep melodi | tracfone free ringtones | free sprint ringtones
190.51.9.* 于 2007-07-12 12:18:13发表:
ad68fa06093b7e357f56ccc0ee04f7d5 http://curia-di-como.gbymyg.org/ http://multipla-nuova.udzjxi.org/ http://ristrutturazioni-edilizie-36.yorcfb.org/ http://adalberto-papa.yorcfb.org/ http://tassi-d-interesse-agevolati-mutuo-bancari.qeeuwf.org/ http://riflessioni-pace.mtfkmx.org/ http://forma-vaso-greco.qeeuwf.org/ http://le-avventure-di-jim-bottone.bmfcxx.org/ http://nuovo-modello-alfaromeo.rtistm.org/ http://scarica-c-dex.qpjnvy.org/ d8d97f68bc274489b372d34e17b3a169
72.36.192.* 于 2007-07-12 08:00:08发表:
Great work!
free slot games online | slots download | slot machine software | empire poker | world series of poker download | free online bingo games | download free poker games | russian roulette | online free poker | free strip blackjack
72.36.192.* 于 2007-07-12 07:59:46发表:
Thank you!
gambling machines | online texas hold em | slot machines | free slot machine downloads | free online poker | free no deposit casinos | strip blackjack games | slot games free | free casino bonus | slot machine games free
72.36.192.* 于 2007-07-12 07:58:37发表:
Thank you!
free blackjack games | online slot machines | black jack download | cleopatra slot | free blackjack | monopoly online | casino download | poker games | no deposit casinos | play free slots online
72.36.192.* 于 2007-07-12 07:58:13发表:
Well done!
no deposit casino | poker games free | free strip black jack | free on line slots | free slots | no deposit bonuses | free slot machines | online casino bonus | online gambling sites | on line gambling
72.36.192.* 于 2007-07-12 07:58:05发表:
Good design!
casino bonus | best online casino games | play free slots | virtual poker | texas hold em free | internet poker | free monopoly online | online holdem | free poker games | free online poker game