经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-06-15 08:27:38发表:
Well done!
download free mac poker strip | play slot | pacific poker software | free poker tournament online | masque publishing free game downloads slots | world poker tournament | free monopoly slots | free texas hold em poker games | pachislo slot machines nj | online poker texas holdem
72.36.192.* 于 2007-06-15 08:27:29发表:
Great work!
best onlline slots | casino poker rooms reviewed | free poker for mac | play giant size cards video pokercasino games for free | partypoker sign up bonus code | dice games to play | best gambling sites | free blackjack downloads | free online slot machines for fun no download | no download free roulette
201.253.166.* 于 2007-06-14 20:49:57发表:
964dcb8b590e0fe2e825a61136dccfdb http://nqdwgl.org http://www.hoyscj.org http://nqdwgl.org http://bwmuus.org http://www.kcxesd.org http://uzgvit.org http://www.kgsisp.org http://www.hoyscj.org http://www.leuawf.org http://www.kcxesd.org a4d20a8afbc395002366bd667860c4d3
72.36.192.* 于 2007-06-14 08:28:13发表:
Good design!
free country music ringtones | motorola razr v3 ringtones | free ringtones for alltel | alltel free ringtones | free ringtones for lg | nextel ringtone program | free music ringtones | free nokia ringtones | free 24 ringtone | free ringtones sprint
72.36.192.* 于 2007-06-14 08:27:51发表:
Well done!
wav ringtones | download ringtones | download free nokia ringtone | razr v3 ringtones | free mobile phone ringtones | polyphonic ringtone | free real music ringtones | mp3 ringtones | funny ringtone | ringtone
72.36.192.* 于 2007-06-14 08:26:38发表:
Good design!
free hifi ringtones | boost mobile ringtones | free ringtones for cingular | free ringtones for us cellular | free ringtones for t mobile | free ringtone download | free ringtones download | free ringtones lg | free suncom ringtones | free harry potter ringtones
72.36.192.* 于 2007-06-14 08:26:13发表:
Great work!
mp3 ringtone | free cellular south ringtones | nextel downloads | verizon ring tones | motorola ringtone | free ringtones | cell phone ringtones | verizon ringtones free | free nokia downloads | motorola free ringtones
72.36.192.* 于 2007-06-14 08:26:02发表:
Nice site!
anime ringtones | 24 ring tone | free ringtone converter | free ringtone creator | mp3 ringtone download | sprint pcs ringtones | star wars ringtone | free ringtones | verizon ringtones | polyphonic ringtones
83.252.235.* 于 2007-06-13 20:12:11发表:
0c525affb29efc83d5dd89c56866c7eb http://etpdkj.org http://atnota.org http://www.xgjrbe.org http://atnota.org http://www.pdhctn.org http://www.nbtxan.org http://nbtxan.org http://gwxvqe.org http://vtqzvy.org http://vtqzvy.org 0f5fa03e3dca64d5b4cd330c6f860531
60.176.81.* 于 2007-06-13 10:26:37发表:
72.36.192.* 于 2007-06-13 08:25:23发表:
Thank you!
play slots for free | internet casino casino online casino | casino games free no download | play blackjack for free online | free poker | slot machine games | free sign up bonus no deposit poker | free online slot games | internet casinos gambling | 8ball slots games
72.36.192.* 于 2007-06-13 08:24:41发表:
Nice site!
no depositno download bingo | online casinos | yahoo poker games | free download strip black jack andnot online | online casino games | place bets casino | play price is right casino game free | blackjack online | blackjack gambling | free money casino
72.36.192.* 于 2007-06-13 08:23:40发表:
Well done!
download casino games | free casino gambling win prizes | online holdem poker | casino black jack | play free no download slot machines | free blackjack game | hoyle casino empire | pickem poker video games | mega bingo keno | unbiased online baccarat review
72.36.192.* 于 2007-06-13 08:23:24发表:
Thank you!
play bingo for kids online | casino | multiline slots | high roller gambling | free casino card games | casino free online | black jack software | blackjack download free | no deposit free sign up bonus bingo | play giant size cards video pokercasino games for free
72.36.192.* 于 2007-06-13 08:23:10发表:
Great work!
free games on line | bugle bingo | online poker real money | free signup bonus poker | online casino reviews | poker game | online casino online poker | free bonus screen online slots | free poker on line games | poker online play money
83.57.132.* 于 2007-06-12 21:19:09发表:
7e456695617dd4eb8c6b4ffb12f85fac http://360-modena-for-sala-italy.rivotb.org/ http://sezione-controllo-corte-dei-conto.hivfbp.org/ http://decreto-ingiuntivo-t-f-r.ammyco.org/ http://investimenti-diretti-esteri-in-italia.okhyez.org/ http://visita-natalizia-famiglia-parte-dei-laici.rivotb.org/ http://scuole-di-teatro-a-roma.okhyez.org/ http://ciclo-miele-didattica-scuola-elementare.xxcgwu.org/ http://apri-file-libreria-visual-basic.xxcgwu.org/ http://c-s-napoli-bdp-it.kiyytw.org/ http://scarpa-calcetto-nike-total-magia.kiyytw.org/ 416778d26f8af0e18aadb8d947bc0aec
72.36.192.* 于 2007-06-12 08:21:11发表:
Good design!
online poker for windows or mac | free bonus slots | online holdem poker | saint and sinners bingo download | online blackjack games | las vegas online casino | party bingo | online casino poker reviews | free poker downloads for compaq | free downloadable bingo games no deposit
72.36.192.* 于 2007-06-12 08:20:39发表:
Well done!
online gamblingcredit card | fivecard stud poker | most reliable reputable video poker online casinos | online poker edge noble free cash | instant no deposit casinos with bonus codes | roulette casino | free slots and keno game | internet poker web sites | absolute poker play money | best casino bonus online
72.36.192.* 于 2007-06-12 08:19:45发表:
Good design!
party poker deposit codes | multi line slots | online video poker game | free carribean stud poker | play keno online | download free bingo | free onlinecasino games | sim slots | roulette andnot online casino russian | bingo game download for free
72.36.192.* 于 2007-06-12 08:19:22发表:
Thank you!
dice rolling programs | free texas holdem poker play | paying online baccarat sites | free bingo cash no deposit | bonus codes no deposit casino | free online texas holdem | play roulette | free roulette game | online gambling legal | baccarat gambling
72.36.192.* 于 2007-06-12 08:19:10发表:
Great work!
free texas holdem tournament | virtual city casino | casino best offers | 15 line slots free no down loading | aussie slots | free munster slot machine online | roulette casino gambling | free poker download | black jack online gambling | free online holdem poker
84.122.112.* 于 2007-06-11 22:02:02发表:
f8945b3bf39467e6e69c952ca6ba234e http://software-patente-guida-b-auto.guqsuy.org/ http://prodotti-per-la-sicurezza-in-mare.guqsuy.org/ http://il-bacio-di-francesco-hayez.ljiwrk.org/ http://wimax-site-telefonino-leonardo-it.cckzfi.org/ http://giornata-dell-orgasmo-22-dicembre.guqsuy.org/ http://vino-pinot-nero-villa-di-bagnolo.fkgkox.org/ http://facolta-di-scienze-politiche-bologna.guqsuy.org/ http://detrazione-abitazione-principale-residenza-ici.cckzfi.org/ http://foto-solo-grande-seno-naturale.hzuhtu.org/ http://elenco-ordine-dei-medico-torino.uoyrgt.org/ 3ebbdc0c5c788c89d957115fc277340d
72.36.192.* 于 2007-06-11 08:24:54发表:
Well done!
us cellular ring tones | samsung ringtones | cisco ringtones | midi ringtones | mp3 ringtones download | ringtone jukebox | ring tones | sanyo ringtones | free ringtones | online ringtone converter
72.36.192.* 于 2007-06-11 08:24:25发表:
Thank you!
mtv ringtones | lg ringtones | mosquito ringtone | sprint pcs ringtones | free cell phone ring tones | free ringtones for alltel | free ringtones for tracfone | centennial wireless ringtones | ringtones samsung | hindi ringtone
72.36.192.* 于 2007-06-11 08:23:24发表:
Nice site!
motorola razr v3 ringtones | cellular south ringtones | wwe ringtones | free ringtone | verizon ringtones free | crazy frog ringtones | motorola ringtones | free composer ringtones | free ringtones for nokia | cricket ringtones
72.36.192.* 于 2007-06-11 08:23:07发表:
Nice site!
free wav ringtones | ctu 24 ringtone | mobile phone ringtones | polyphonic ringtone | free ringtones for tracfones | us cellular ringtones | ringtone free | free ringtones for t mobile | ringtones 24 | 24 ctu ringtones
72.36.192.* 于 2007-06-11 08:22:58发表:
Thank you!
bollywood ringtones | free christian ringtones | free 24 ringtone | download free motorola ringtone | free star wars ringtones | ctu ringtone verizon | free country ringtones | real music ringtones | download free polyphonic ringtones | ringtone websites
62.42.38.* 于 2007-06-10 21:49:03发表:
6ac8678c4cfb09942d137ed35f6f3cf4 http://cerco-lavoro-bologna-e-provincia.mksqkw.net.in/ http://prestito-santo-stefano-di-camastra.kfxrfs.net.in/ http://giorgio-alfieri-tronista-uomo-donna-ultima.dtifhu.net.in/ http://case-in-affitto-verderio-superiora.dtifhu.net.in/ http://graduatoria-concorso-mag-1999-2000.oaxzml.net.in/ http://pompino-bocchino-sbora-bocca-foto.dtifhu.net.in/ http://dbz-movie-07-invasione-neo-namek.oaxzml.net.in/ http://donna-mature-fanno-sesso-con-animali.ooqqld.net.in/ http://vanni-bucci-boston-amico-firenze.mksqkw.net.in/ http://gigi-d-alessio-made-italy-ilaria.kfxrfs.net.in/ 319dbbb4ab069a1bfb4a4d4d12c61dcd
60.176.83.* 于 2007-06-10 20:03:19发表:
监控,。。
72.36.192.* 于 2007-06-10 07:58:27发表:
Nice site!
mp3 ringtones | 24 ctu ringtones | ctu ringtone verizon | ringtone mp3 | bollywood ringtones | free cricket ringtones | crazy frog ring tone | ringtones samsung | free real ringtones for cingular | free mp3 ringtone downloads
72.36.192.* 于 2007-06-10 07:57:48发表:
Good design!
free star wars ringtones | free ringtones alltel | polyphonic ringtone | mp3 ringtones download | mosquito ringtone | midi ringtone | cingular wireless ringtones | free ringtones | eminem ringtones | samsung ringtones
72.36.192.* 于 2007-06-10 07:57:02发表:
Well done!
razr ringtones | free midi ringtones | motorola razr v3 ringtones | polyphonic ringtones | free motorola ringtones | free ringtones for tmobile | ringtones free | nextel ringtone program | cellphone ringtones | free ringtones for u s cellular
72.36.192.* 于 2007-06-10 07:56:47发表:
Good design!
country ringtones | free ringtones for lg | voice ringtones | online ringtone converter | free composer ringtones | free nascar ringtones | christian ringtones | free anime | nokia download | verizon ctu ringtone
72.36.192.* 于 2007-06-10 07:56:39发表:
Nice site!
free sms ringtones | ringtones 24 | sanyo ringtones | nokia free ringtones | free wav ringtones | ringtones for tracfone | cell phone ringtones | free mp3 ringtones | free ringtone creator | download free ringtone
89.159.194.* 于 2007-06-09 20:39:20发表:
647ff8ad5e0d336beb7dfbb0f36c33c7 http://britney-official-site.blogspot.com/ http://blog.myspace.com/196097962 http://offerta-viaggio-1-al-5-gennaio.hhknox.co.in/ http://blog.myspace.com/196093926 http://blog.myspace.com/195751575 http://britney-official-site.blogspot.com/ http://blog.myspace.com/196097101 http://agenzia-viaggio-spedizioni-palermo-barcellona.pifljm.co.in/ http://blog.myspace.com/196097962 http://ricorso-canone-rai-non-dovuti.hhknox.co.in/ 48c0bb0f30b00789fa1734f152bbea8f
72.36.192.* 于 2007-06-09 07:50:53发表:
Well done!
online gambling | slot machine games | on line poker | play online poker | free online video slots | free casino slot | casino free games | free slot play | play blackjack free | free poker software
72.36.192.* 于 2007-06-09 07:50:32发表:
Thank you!
poker online free | best usa casino online | russian roulette | blackjack online | poker games online | free internet poker | play roulette | play poker | no deposit bonus casinos | slot machine game
72.36.192.* 于 2007-06-09 07:49:22发表:
Thank you!
internet gambling | deposit bonus casino | online black jack game | video poker free | free online blackjack | sims free slots | play texas holdem | sims slots | free video slot games | free monopoly online
72.36.192.* 于 2007-06-09 07:49:01发表:
Great work!
online slot machines | free money casino | free casino bonus | best poker sites | free poker downloads | play texas hold em | poker websites | video slot machines | online poker games | black jack online
72.36.192.* 于 2007-06-09 07:48:48发表:
Well done!
free video poker | video poker | free texas hold em | play casino games | free poker on line | video slots free | free black jack game | internet casinos | internet casino games | online bingo games