经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
62.118.42.* 于 2007-03-03 18:36:18发表:
I don't know how long it has been up and running but I just love this website! verizon ringtones add your link payday loan fast money payday loan faxless payday loan no fax no hassle payday loan payday loan colorado fast easy payday loan lil scrappy ringtone online payday loan in georgia canada instant payday loan
0.0.0.* 于 2007-03-03 18:10:33发表:
Keep up the great work. Keep it up! world net jackpot casino book casino gamble line sport 100 no deposit casino sim slots game secure online casino casino chip supplier ameristar casino kansas city golden palace online casino free 5 reel slots 50 lion machine slots video
63.147.134.* 于 2007-03-03 18:02:18发表:
Hi! Love your site.. Looks really amazing compared even to the best pages on the Web ever! game leprechaun slots video lauberge du lac casino lake charles backgammon game download video strip poker access code online casino coupon code free cash portable blackjack table casino style poker chips free online casino game lake charles casino tropicana hotel casino nj
0.0.0.* 于 2007-03-03 17:31:09发表:
Great work! free monopoly online slots karen strip blackjack baccarat link suggest russian roulette flash foxwoods resort casino hotel no deposit bonus online casino tropicana casino in las vegas casino los angeles indian playing roulette play free casino slots free
213.240.225.* 于 2007-03-03 17:28:21发表:
Many thanks! 500 no fax payday loan easy online payday loan overnight no fax payday loan cheap payday loan 100 no fax payday loan faxless payday loan payday loan store instant approval payday loan free real music ringtones sprint no faxing payday loan
218.108.41.* 于 2007-03-03 16:50:28发表:
Just wanted to tell you the web site is fantastic!!!!!!!! penny video poker online casino play online casino venetian hotel casino las vegas nv pro and cons of casino gambling best casino online web baccarat paperweights casino foxwoods map on line internet casino blackjack card game online roulette winning tip
218.94.80.* 于 2007-03-03 16:46:12发表:
I love the website! It is crisp and full of information. I really like this site I visit it often. Keep up the good work! payday loan paycheck advance quick faxless payday loan fast payday loan inc free bollywood ringtone no credit check payday loan money tree payday loan instant cash payday loan new payday loan company no fax no hassle payday loan online payday loan service
200.233.74.* 于 2007-03-03 16:28:16发表:
Your web site is really helpful! Clean and loaded with info. craps table diagram roulette table casino royale bond craps payouts casino play online poker for fun avalon ballroom casino fallsview adult black flash jack strip download hoyle casino noble game backgammon casino gaming table
211.116.133.* 于 2007-03-03 16:21:59发表:
I want to thank you for doing so much for us. What you've done for us is long overdue. best gambling online blackjack free casino web game casino en indian language ballys casino tunica roulette system forum pala casino employment free casino sims slots palm casino resort casino bonus coupon pala casino pala ca
213.136.234.* 于 2007-03-03 16:13:11发表:
Your site is great no credit check payday loan payday loan no faxing required payday loan young gunz ringtones 200 faxless payday loan payday loan no fax document payday loan colorado free cell ringtones payday loan arizona quik payday loan
0.0.0.* 于 2007-03-03 16:11:52发表:
I love the website! It is crisp and full of information. I really like this site I visit it often. Keep up the good work! payday loan application 1000 online payday loan canadian payday loan online free mobile phone ringtone ringtone converter canada payday loan online online payday loan application fast faxless payday loan e z payday loan emergency payday loan
89.106.68.* 于 2007-03-03 16:11:12发表:
I love the website! It is crisp and full of information. I really like this site I visit it often. Keep up the good work! payday loan application 1000 online payday loan canadian payday loan online free mobile phone ringtone ringtone converter canada payday loan online online payday loan application fast faxless payday loan e z payday loan emergency payday loan
0.0.0.* 于 2007-03-03 16:08:38发表:
Your site is great no credit check payday loan payday loan no faxing required payday loan young gunz ringtones 200 faxless payday loan payday loan no fax document payday loan colorado free cell ringtones payday loan arizona quik payday loan
0.0.0.* 于 2007-03-03 16:05:30发表:
Many thanks! drive me crazy ringtones payday loan debt easy no fax payday loan no faxing instant payday loan payday loan paycheck advance jennifer lopez ringtone no bank statement payday loan utah payday loan company no faxing instant payday loan salt lake payday loan
0.0.0.* 于 2007-03-03 16:02:59发表:
Good work. guaranteed no fax payday loan cash america payday loan bad credit payday loan quick payday loan no fax no call t mobile ringtone payday loan calculator quick faxless payday loan payday loan 1000 free payday loan no fax payday loan company
200.124.231.* 于 2007-03-03 15:58:44发表:
My fiancee and I just moved here from out east. I just wanna tell you that we love this website! tech n9ne ringtones payday loan online bad credit no fax payday loan cash advance instant faxless payday loan payday loan las vegas check to cash payday loan no fax required payday loan payday loan arizona faxless bad credit payday loan no faxing needed payday loan
0.0.0.* 于 2007-03-03 15:44:06发表:
Great site! I was happy to learn about it. fast faxless payday loan same day payday loan instant online payday loan free ringtone for cricket phone low fee faxless payday loan cash reserve payday loan faxless and paperless payday loan nine inch nail ringtones free blackberry ringtone new faxless payday loan
0.0.0.* 于 2007-03-03 15:16:24发表:
We will definitely be checking in on a regular basis to see how the site is growing. no fax needed payday loan bad credit payday loan guaranteed payday loan payday loan las vegas payday loan fast approval payday loan faxless bad credit payday loan payday loan on line online payday loan application payday loan with guaranteed no faxing
0.0.0.* 于 2007-03-03 15:15:31发表:
I will recommend it! cash net payday loan advance america payday loan faxless one hour payday loan quick faxless payday loan missouri payday loan fast internet payday loan canadian payday loan low fee payday loan limp bizkit ringtone tina turner ringtones
0.0.0.* 于 2007-03-03 15:11:32发表:
Many thanks. payday loan oregon fast auto and payday loan payday loan kansas payday loan on line 1000 advance payday loan free ringtones for cricket phone online savings account payday loan payday loan calculator cash america payday loan 1 hour payday loan
68.145.135.* 于 2007-03-03 15:11:07发表:
The site is easy to use and very helpful. Thank you for this wonderful service. I am recommending it to everyone. personal loan not payday loan fax payday loan cheap payday loan georgia payday loan quik payday loan payday loan paycheck advance free real music ringtones for nextel short term payday loan savings account payday loan no fax no credit payday loan
68.145.135.* 于 2007-03-03 15:10:12发表:
Very useful! cash advance payday loan payday loan las vegas savings account no fax payday loan fast internet payday loan no fax payday loan missouri 100 no fax payday loan fast easy payday loan free verizon cell phone ringtones no fax payday loan online payday loan application
0.0.0.* 于 2007-03-03 15:08:51发表:
This site is wonderful. bad credit no payday loan missouri payday loan online limp bizkit ringtone personal no fax payday loan quick cash payday loan georgia payday loan free cell ringtone faxless online payday loan fast payday loan no faxing online payday loan application
0.0.0.* 于 2007-03-03 15:08:23发表:
Nice site man! free music ringtone no faxing instant payday loan free boost mobile ringtone canadian payday loan faxless low cost payday loan payday loan 1000 payday loan faxless no fax 1 hour faxless payday loan payday loan colorado ez payday loan
68.145.135.* 于 2007-03-03 15:08:00发表:
Thank you. This has a great potential. payday loan no fax no call payday loan kansas military payday loan personal loan not payday loan payday loan no faxing required completely faxless payday loan faxless payday loan same day bad credit no payday loan cash advance payday loan georgia payday loan
213.240.225.* 于 2007-03-03 13:07:46发表:
debt consolidation program al http://debtconsolidationprogramalmbshh.blogspot.com debt consolidation program al debt consolidation program uk debt consolidation program uk http://debtconsolidationprogramukcfp.blogspot.com debt consolidation program indiana debt consolidation program indiana http://debtconsolidationprogramindianaicgof.blogspot.com secured debt consolidation http://secureddebtconsolidationuyk.blogspot.com secured debt consolidation keyword debt consolidation program keyword debt consolidation program http://keyworddebtconsolidationprogramgiswek.blogspot.com debt consolidation http://debtconsolidationluh.blogspot.com debt consolidation arizona debt consolidation loan arizona debt consolidation loan http://arizonadebtconsolidationloankoksvi.blogspot.com debt consolidation uk debt consolidation uk http://debtconsolidationukhvm.blogspot.com debt consolidation calculator debt consolidation calculator http://debtconsolidationcalculatorctd.blogspot.com debt consolidation company in me http://debtconsolidationcompanyinmehepwm.blogspot.com debt consolidation company in me
125.90.64.* 于 2007-03-03 09:13:52发表:
fast cash advance http://fastcashadvancedtacsh.blogspot.com fast cash advance cash advance las vegas cash advance las vegas http://cashadvancelasvegaslmgaw.blogspot.com payday cash advance new york http://paydaycashadvancenewyorktcim.blogspot.com payday cash advance new york pay day cash advance http://paydaycashadvancembdbw.blogspot.com pay day cash advance http://paydaycashadvancenewmexicoekp.blogspot.com payday cash advance new mexico payday cash advance new mexico http://quickandeasycashadvancemglmy.blogspot.com quick and easy cash advance quick and easy cash advance lawsuit cash advance usa lawsuit cash advance usa http://lawsuitcashadvanceusabio.blogspot.com check cash advance loan http://checkcashadvanceloanwmpiwv.blogspot.com check cash advance loan cash advance credit card cash advance credit card http://cashadvancecreditcardsmss.blogspot.com need a fast cash advance http://needafastcashadvancesgrtg.blogspot.com need a fast cash advance
65.110.43.* 于 2007-03-03 09:13:31发表:
Well done!
flash casino | strip black jack | free roulette online | texas holdem online | absolute poker | strip blackjack | poker software | slots download | free casino downloads | download free poker
65.110.43.* 于 2007-03-03 09:13:01发表:
Great work!
download free poker game | free blackjack online | blackjack strip | monopoly slots | star poker | online poker sites | casino poker | black jack online | online poker games | new no deposit online casinos
72.232.250.* 于 2007-03-03 09:12:42发表:
Thank you!
free money casinos | free slot machine games online | online blackjack free | free slots machines | play texas holdem | play roulette free | online games | free slots | blackjack download | virtual poker
72.232.250.* 于 2007-03-03 09:12:28发表:
Thank you!
no download slots | online bingo | free slot play | planet poker | no download casino | free slots no download | free video | free slot downloads | on line poker | computer poker
72.232.250.* 于 2007-03-03 09:12:10发表:
Good design!
three card poker | free black jack | poker free | video slot games | free roulette games | poker online | slot machine software | free download poker | paradise poker | free online gambling
0.0.0.* 于 2007-03-03 08:46:17发表:
juego interactivo internet juego interactivo portales web http://casinoenlinea.xlphp.net/juego-interactivo-3.html giochi internet giochi internet http://pokergra01.ds4a.com/giochi-2.html online poker spiel top online poker http://www.free-hoster.cc/users/freierpoker/online-poker-3.html http://free-host.de/ringtonezz/free-ringtones-5.html 100 free ringtones free ringtones juegos azar pagina internet http://pokerenlinea.prophp.org/juegos-azar-3.html juegos azar paginas internet http://casinos001.nm.ru/online-poker-2.html online poker game play poker online http://www.gratisweb.com/rngtonez/free-ringtone-3.html free tracfone ringtone free ringtone promozioni in linea superiori casinos gratuiro http://poker888.po.ohost.de/casino-2.html http://www.homepagez.com/toppromo/jeu-poker-3.html jeu flash gratuit jeu flash usher ringtones free mobile ringtones http://www.clps.ttct.edu.tw/kjasp/ch11/Detail.asp?TitleID=857
0.0.0.* 于 2007-03-03 08:38:18发表:
http://downloadfreemp3ringtonepoadg.blogspot.com download free mp3 ringtone download free mp3 ringtone free ringtones free ringtones http://freeringtoneskun.blogspot.com selena ringtones selena ringtones http://selenaringtonesvpgch.blogspot.com http://freepolyphonicringtonesdownloadoybsr.blogspot.com free polyphonic ringtones download free polyphonic ringtones download free cingular cell phone ringtones free cingular cell phone ringtones http://freecingularcellphoneringtonesvdlccb.blogspot.com http://freeuscellularringtonestoh.blogspot.com free us cellular ringtones free us cellular ringtones nextel ringtones nextel ringtones http://nextelringtonesmbbem.blogspot.com download free ringtone t mobile http://downloadfreeringtonetmobileprdvo.blogspot.com download free ringtone t mobile free mp3 ringtones free mp3 ringtones http://freemp3ringtoneswoas.blogspot.com relient k ringtone relient k ringtone http://relientkringtonebulskt.blogspot.com
0.0.0.* 于 2007-03-03 08:28:58发表:
http://cashadvanceloannofaxingtmgg.blogspot.com cash advance loan no faxing cash advance loan no faxing free ringtones for sprint phone free ringtones for sprint phone http://freeringtonesforsprintphonervdfn.blogspot.com free alltel ringtones free alltel ringtones http://freealltelringtoneskume.blogspot.com sprint ringtones http://sprintringtoneseorob.blogspot.com sprint ringtones http://freetracfoneringtonervvui.blogspot.com free tracfone ringtone free tracfone ringtone http://cashadvanceportlandoregonbvnoi.blogspot.com cash advance portland oregon cash advance portland oregon free mobile ringtones free mobile ringtones http://freemobileringtonesitbac.blogspot.com emergency cash advance emergency cash advance http://emergencycashadvanceknvs.blogspot.com free virgin mobile ringtones free virgin mobile ringtones http://freevirginmobileringtonesrwmm.blogspot.com no fax payday cash advance no fax payday cash advance http://nofaxpaydaycashadvancebnngkl.blogspot.com
0.0.0.* 于 2007-03-02 20:24:08发表:
You are the best! payday cash advance free casino money free ringtones maker order viagra roulette online ringtone play blackjack online free kid a ringtones christian debt consolidation program xenical
0.0.0.* 于 2007-03-02 20:23:52发表:
ameriquest co mortgage official site http://ameriquestcomortgageofficialsiteviv.blogspot.com ameriquest co mortgage official site mortgage loan san antonio mortgage loan san antonio http://mortgageloansanantoniooufhcp.blogspot.com colorado mortgage interest rate colorado mortgage interest rate http://coloradomortgageinterestrateevgsg.blogspot.com best find mortgage rate refinance best find mortgage rate refinance http://bestfindmortgageraterefinancevbnv.blogspot.com fixed rate second mortgage fixed rate second mortgage http://fixedratesecondmortgagefwvrcy.blogspot.com mortgage loan information mortgage loan information http://mortgageloaninformationydg.blogspot.com mortgage marketing idea http://mortgagemarketingideawtmrkn.blogspot.com mortgage marketing idea mortgage insurance lead mortgage insurance lead http://mortgageinsuranceleadbnmtvp.blogspot.com hot transfer mortgage lead hot transfer mortgage lead http://hottransfermortgageleadrabnr.blogspot.com mortgage lender pittsburgh mortgage lender pittsburgh http://mortgagelenderpittsburghlsla.blogspot.com
0.0.0.* 于 2007-03-02 20:00:09发表:
Your site is helpful. free fun slots download free cingular ringtone online slots fast cash payday loan low interest payday loan online texas hold em lil wayne ringtones free boost mobile ringtone live poker allied cash advance
0.0.0.* 于 2007-03-02 19:57:12发表:
Your site is great free boost mobile ringtones debt consolidation loan uk credit card debt problem online casino betting cash advance fort worth poker gratuit bad credit debt consolidation loan free payday loan 30 day payday loan consolidation debt link suggest
0.0.0.* 于 2007-03-02 19:43:05发表:
Your web site is really helpful! Clean and loaded with info. jeu casino ligne jeu en ligne lil scrappy ringtones online poker software motorola ringtones meilleures salles de poker 1 hour payday loan free polyphonic ringtone drug detox free real music ringtone for nextel