经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-25 20:01:44发表:
Nice site!
dzwonki na siemensa | download free polyphonic ringtones | klingelton download | ingyen mp3 | country ringtones | ringtones verizon | motorola q ringtones | harry potter ringtones | free ringtones for lg | ringtones
72.36.211.* 于 2007-07-25 20:01:27发表:
Nice site!
free ringtones for cingular | cricket ringtones | lg ringtones | ingyen sms | alltel ringtones | 24 ctu ringtone verizon | keypress ringtones | funny ringtones free | free sanyo ringtones | free motorola ringtone downloads
72.36.211.* 于 2007-07-25 20:01:15发表:
Nice site!
nascar ringtones | free anime ringtones | samsung free ringtones | ctu ring tone | melodie mobil | tracfone free ringtones | download ringtones free | free ringtone creator | 24 ctu ringtones | nextel ringtones
72.36.211.* 于 2007-07-24 19:59:35发表:
Good design!
nextel downloads | free downloadable t mobile ringtones | suonerie cellulare gratis | free ringtones for boost mobile | free christian ringtones | mtv ringtones | free ringtones for nokia | arabic ringtones | country music ringtones | ringtone composer
72.36.211.* 于 2007-07-24 19:59:02发表:
Good design!
free sprint ringtones | ctu ring tone | dzwonki telefon | 50 cent ringtones | sprint pcs ringtones | ringtones wav | verizon ring tones | mp3 to ringtone converter | suonerie polifoniche | mosquito ringtone
72.36.211.* 于 2007-07-24 19:58:06发表:
Nice site!
keypress ringtones | ringtones for tracfone | download free polyphonic ringtones | verizon ringtones free | free star wars ringtones | free ringtone downloads | free ringtone creator | free ringtones for lg | cingular wireless ringtones | samsung melodi
72.36.211.* 于 2007-07-24 19:57:42发表:
Well done!
ringtone midi | free motorola ringtone downloads | free tmobile ringtones | free lg ringtones | free ringtones alltel | us cellular ring tones | sonneries telephone | crazy frog ringtones | logo sonnerie | sonneries gratuites
72.36.211.* 于 2007-07-24 19:57:33发表:
Nice site!
harry potter ringtones | free us cellular ringtones | cingular free ringtones | centennial ringtones | ringtones nokia | bedava melodi | hudba mp3 | free cellular one ringtones | verizon ringtones | toques gratuitos
200.127.50.* 于 2007-07-24 17:50:48发表:
b60d511078dcde7af241afedab042659 http://masterizzatore-dvd-r-dual-layer.ygvhik.biz/ http://parcella-proforma-professionista.kajgdw.biz/ http://comuni-forum.zibtye.biz/ http://billie-myers-discogr.zibtye.biz/ http://ristorante-pampa-jesolo.tzlnou.biz/ http://escort-napoli-forum-escort.iuatju.biz/ http://contattare-zitelle-vogliosa.ppdpwx.biz/ http://plurale-maiestatis-inglese.ppdpwx.biz/ http://europee-2004.zibtye.biz/ http://istruzione-forno-elettrico-whirpool.kajgdw.biz/ 69fae163d26a9b1682339a4eb6fc4ad9
72.36.211.* 于 2007-07-23 19:05:14发表:
Great work!
video poker machines | free texas holdem | slot machines free | games online | poker game online | roulette download | free bonus slots | free sims slots | world series of poker download | free casino game
72.36.211.* 于 2007-07-23 19:04:42发表:
Great work!
new no deposit online casinos | free roulette | download slots | no download free slots | free slot machine | free games online | free blackjack game | online baccarat | on line gambling | play slot machines for free
72.36.211.* 于 2007-07-23 19:03:49发表:
Good design!
video poker | slots for free | on line casinos | casino black jack | play texas hold em | free slots game | free online slots no download | free play slots | poker for free | slots for fun
72.36.211.* 于 2007-07-23 19:03:42发表:
Good design!
free play slot machines | download poker game | internet bingo | online roulette game | russian roulette games | games download | play black jack | poker free | free poker software | casino free game online
72.36.211.* 于 2007-07-23 19:03:17发表:
Thank you!
free online poker game | free bingo | free slot machines games | online poker | casino bonus | poker sites | free slot machines | poker stars download | online strip blackjack | casino poker
82.130.252.* 于 2007-07-23 08:20:31发表:
55c8fe33bcab032db4f05fe89e21a4a7 http://costume-bagno-mare.pvaeyo.org/ http://provveditorato-cuneo.pvaeyo.org/ http://ferito-2002-uganda.pvaeyo.org/ http://amico-jan-peter-pohl.pvaeyo.org/ http://case-in-affitto-san-benedetto-po.cqhnnx.org/ http://leon-d-ora-verona.vywyuh.org/ http://ipasvi-aggiornamento-infermiera-ospedale-maggiore-parma.pvaeyo.org/ http://prodotti-per-vasca-idromassaggio.vywyuh.org/ http://hotel-sala-convegno-bruxelles.jnbwct.org/ http://ccnl-cooperativa-sociale-autista-onlus.gbdrme.org/ eb89aa2351bfb8dd061b0dc25061dcdb
72.36.211.* 于 2007-07-22 19:20:38发表:
Nice site!
ringtones gratis | free mp3 ringtones download | real klingelton | ringtones for nextel | blackberry ringtones | mp3 ringtone download | keypress ringtones | dzwonki do samsunga | us cellular ring tones | free ringtones for tracfones
72.36.211.* 于 2007-07-22 19:19:53发表:
Thank you!
dzwonki na nokie | ringtones for verizon | toques telemoveis | ringtones gratis samsung | sonnerie gratuit | centennial ringtones | country music ringtones | razr ringtones | free ringtones for cellular south | real ringtones
72.36.211.* 于 2007-07-22 19:19:29发表:
Good design!
free ringtones for cricket | free us cellular ringtones | free ringtones for suncom | 24 ringtones | real music ringtones | free ringtones lg | melodias gratis para movil | verizon ringtones free | ringtones wav | handy klingelton
72.36.211.* 于 2007-07-22 19:19:17发表:
Good design!
hudba zdarma | nokia free downloads | nokia downloads | 24 ctu ringtone verizon | free boost mobile ringtones | free mobile ringtones | free real tone ringtones | free ringtone | ingyen mp3 | akon ringtones
72.36.211.* 于 2007-07-22 19:19:04发表:
Nice site!
motorola ring tones | alltel ringtones | free ringtones for motorola | free tracfone ringtones | download free nokia ringtone | ringtone 24 ctu | sprint free ringtones | nextel ringtones | mobil hry | polyphonic ringtones
203.121.69.* 于 2007-07-22 07:53:09发表:
Hi boys! :
free music downloads = music download free = free music = myspace music = free music = legal music downloads = get free ipod music = free mp3 files downloads = downloading song =
http://www.freewebs.com/1fmusic/music-downloads.html free download music :: http://www.tonyshoes.com/albums/musicdownloads/?mp3music=12 music download free :: http://www.freewebs.com/1fmusic/limewire.html download music free :: http://www.tonyshoes.com/albums/musicdownloads/?mp3music=95 myspace music :: http://idisk.mac.com/fmp3musicdownloads/Public/free-music.html free music :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html download music for free :: http://www.freewebs.com/1fmusic/iPod-music.html free ipod downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-mp3-files-downloads.html free mp3 files downloads :: http://www.tonyshoes.com/albums/musicdownloads/?mp3music=84 downloading song :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html download music video :: http://www.tonyshoes.com/albums/musicdownloads/?mp3music=117 free music downloading programs ::
mp3 downloads .. music download free .. download music for free .. myspace music .. free music .. download music for free .. free ipod music downloads sites ..
125.118.35.* 于 2007-07-22 05:52:33发表:
服务操作
72.36.211.* 于 2007-07-21 21:07:51发表:
Great work!
no deposit online casino | no deposit bonus | play roulette | free texas holdem online | free poker games | online holdem | poker game online | free online bingo games | online slot machines | russian roulette game
72.36.211.* 于 2007-07-21 21:07:12发表:
Good design!
free online poker game | free video slots | free online bingo | free online texas holdem | casino games online | slots free | game slot | pacific poker | russian roulette games | new casinos
72.36.211.* 于 2007-07-21 21:06:24发表:
Great work!
poker games free | free no deposit casino | slim slots | games on line | free on line slots | black jack strip | video slots | free casino slot | play roulette for free | poker game free
72.36.211.* 于 2007-07-21 21:06:06发表:
Well done!
download free poker games | free slot play | free texas hold em | free poker software | download blackjack | free monopoly slots | texas hold em | no deposit bingo | poker games | free gambling
72.36.211.* 于 2007-07-21 21:05:54发表:
Well done!
free roulette | new online casinos | roulette game | free slots downloads | black jack download | strip blackjack | play blackjack free | texas holdem free online | strip blackjack games | free casino
72.36.211.* 于 2007-07-20 20:56:02发表:
Great work!
poker free | computer poker | monopoly slot machine | free no deposit casino | free slot downloads | party poker download | free slots games | poker stars | online bingo games | online free roulette
72.36.211.* 于 2007-07-20 20:55:34发表:
Nice site!
no deposit casinos | slots of fun | new no deposit casinos | world series of poker | world poker | free online slot machine | free slots downloads | casino bonus | free sim slots | texas holdem free
72.36.211.* 于 2007-07-20 20:54:32发表:
Thank you!
download blackjack | free blackjack online | online poker sites | blackjack software | free poker | download poker | free strip blackjack | gambling machines | casino deposit bonus | free casino cash
72.36.211.* 于 2007-07-20 20:54:07发表:
Thank you!
best poker sites | free texas holdem | poker machines | cleopatra slots | free texas holdem online | on line gambling | internet casino games | free online slots games | online slots | free casino bonus
72.36.211.* 于 2007-07-20 20:53:57发表:
Well done!
slots for fun | strip blackjack | black jack download | play free blackjack | paradise poker | download party poker | black jack | online baccarat | strip blackjack free | play roulette
221.153.240.* 于 2007-07-20 16:19:39发表:
e718d619977c2484b177e262b456ea56 http://tassaimportazioneauto.kprskz.org/san-diego-attrazioni/ http://giocoedenigmi.cerfmd.org/hotel-bolzano-offerta/ http://volobarimalpensa.pehabe.org/abilitazione-docenti/ http://andreaniadrianorieti.cerfmd.org/cartagine-tunisia/ http://bloccocircolazionenapoli19.qemqrg.org/campo-san-maurizio/ http://appaltocomunali.pykkxx.org/castiglione-della-pescaia-hotel/ http://letteralegali.qemqrg.org/palii-piu-famosi-d-italia/ http://materassofalomo.ghoouy.org/voli-aerei-alicante/ http://chimairavaleriomassimo.pehabe.org/living-divano/ http://rominapowerscherzoparte.chohqh.org/orario-autobus-sciacca-palermo/ b8fb7d84153cc5c69600cbe1497734b2
72.36.211.* 于 2007-07-19 20:59:52发表:
Great work!
tonos para celular | handy klingelton | ringtones wav | sprint phones | ringtone motorola | free kyocera ringtones | gospel ringtones | ringtones for sprint phones | dzwonki do samsunga | polifonik melodi
72.36.211.* 于 2007-07-19 20:59:18发表:
Thank you!
ingyen sms | centennial wireless | free ringtones for alltel | free ringtone converter | mp3 ringtones download | sonnerie portable | free ringtones for lg | lg ringtones | hudba zdarma | suncom ringtones
72.36.211.* 于 2007-07-19 20:58:26发表:
Good design!
monophonic ringtones | ringtones verizon | christina aguilera ringtones | download free ringtones | gratis mobilspel | gwen stefani ringtones | sprint ringtones | free christian ringtones | tmobile ringtones | toques gratis
72.36.211.* 于 2007-07-19 20:57:59发表:
Good design!
cep telefonuna melodi | mp3 klingelton | hifi ringtones | verizon free ringtones | logo sonnerie | mp3 ringtones free | toques reais | darmowe dzwonki | motorola ringtones free | free nextel ringtone downloads
72.36.211.* 于 2007-07-19 20:57:45发表:
Good design!
free 24 ctu ringtone | free mp3 ringtones | free harry potter ringtones | goedkope ringtones | u s cellular ringtones | free mp3 tones | mobil telefon | free ringtones for u s cellular | ringtone 24 ctu | ringtones mp3
190.73.35.* 于 2007-07-19 06:50:28发表:
2f7db7ab8a9676c1fb6ac3ecfe6b1dd3 http://specialisti-oculistica.qeshtw.in/ http://asilo-nido-gemona-friuli.qeshtw.in/ http://domanda-matrimonio-cechov.qeshtw.in/ http://autolavaggio-self-service-provincia-ferrara.jvzulp.in/ http://top-escort-bolzano.miwcjz.com/ http://ww-vodafone190-it.jvzulp.in/ http://valle-d-aosta-curiosita.licoxi.in/ http://selene-dea-della-luna.licoxi.in/ http://dante-alighieri-la-monarchia.miwcjz.com/ http://causa-rimedio-caviglia-gonfie.qeshtw.in/ b8a12f78e2ab8d9c8e5e94f78e975725
72.36.211.* 于 2007-07-18 21:14:40发表:
Good design!
free internet poker | free online slots no download | strip black jack | play bingo | free slots | free slots | blackjack for free | free three card poker | internet gambling | free gambling games