经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
0.0.0.* 于 2007-03-06 01:39:34发表:
Amazing site! game link roulette suggest free bonus slots learn online poker rule video slim slots casino backgammon checkers chess game set gambling tip blackjack casino indiana map slots machine for sale hard rock hotel casino vegas casino and chandler arizona
24.151.135.* 于 2007-03-06 01:28:28发表:
Great site! I was happy to learn about it. black gambling jack moes free backgammon on line ho slots car wheels free poker poker video video casino slots gambling mohegan sun casino connecticut best rated online casino cash casino calgary casino net casino casino code coupon deposit no online
0.0.0.* 于 2007-03-06 01:23:09发表:
Thank you for your hard work in providing this excellent service to our wonderful worldbour!! It will be such a help to stay informed of so much that's happening. sport book horse casino video strip blackjack baccarat game on line video slots with bonus paragon casino marksville louisiana showboat hotel and casino indiana river boat casino new casino bonus code slots machine bank play free online video poker
0.0.0.* 于 2007-03-06 01:14:22发表:
I will be back! free casino game top recommended link internet craps game blackjack ballroom casino online river rock casino resort venetian casino las vegas tunica casino jobs blackjack game for fun harrahs casino atlantic city used blackjack table no deposit flash casino
213.240.225.* 于 2007-03-06 00:35:46发表:
Great site! I find it very helpful. mandalay bay casino ameristar casino hotel sims free casino slots game slots car track in ohio california casino directory indian free video poker strategy card roulette betting system video poker machine sales baccarat restaurant shooting craps
210.196.205.* 于 2007-03-06 00:33:47发表:
I love everything about your site. casino style poker chips new casino niagara hilton casino atlantic city nj casino how to win at slots casino n net fallsview casino hotel free video slots game free roulette professional system improv at hard rock casino bay casino chip mandalay
0.0.0.* 于 2007-03-06 00:23:24发表:
You have created a wonderful site for the virtual community. Congratulations!! scx slots car racing book online roulette win craps gambling rule hollywood park casino inglewood ca casino download free money no free slots and bingo safe online casino atlantic casino city in luxury resort ho slots car texas tea slots machine
66.35.163.* 于 2007-03-06 00:07:10发表:
I have already found your site to be very helpful. It is especially nice for newcomers as well as people that have been here for a while. I am sure I will come and check it often. bingo casino gambling online poker bet betting casino gambling casino download free money no palm beach casino line roulette wheel casino slots game no download blackjack odds free slots play and win hooters hotel casino las vegas backgammon tutor
0.0.0.* 于 2007-03-05 23:59:25发表:
I have already found your site to be very helpful. It is especially nice for newcomers as well as people that have been here for a while. I am sure I will come and check it often. bingo casino gambling online poker bet betting casino gambling casino download free money no palm beach casino line roulette wheel casino slots game no download blackjack odds free slots play and win hooters hotel casino las vegas backgammon tutor
0.0.0.* 于 2007-03-05 23:52:55发表:
Great site! I was happy to learn about it. video poker cheat nation pollen slots video car custom slots track winning slots machine casino in palm desert belle terra casino indiana internet gambling slots machine roulette gambling casino craps table layout download free machine pc slots
0.0.0.* 于 2007-03-05 23:36:51发表:
Great Job! soaring eagle casino caesars casino in atlantic city river rock casino resort ameristar casino hotel casino deposit forum no rtg casino foxwoods picture stratosphere casino hotel tower palm hotel casino las vegas nv hard rock casino tampa florida free casinos
0.0.0.* 于 2007-03-05 23:26:10发表:
Hi! Love your site.. Looks really amazing compared even to the best pages on the Web ever! palm springs casino hotel blackjack table cover atlantic city casino guide the best online casino on the net casino rama package casino game internet virtual free roulette download casino blackjack and poker table jackpot party video slots blackjack odds card
0.0.0.* 于 2007-03-05 23:23:46发表:
Please check out this website: casino gambling online poker video free video poker no download frontier hotel and casino las vegas backgammon set hollywood park casino inglewood ca free slots how to play craps grand casino coushatta louisiana suncoast hotel and casino party backgammon
0.0.0.* 于 2007-03-05 23:09:29发表:
Great site! I find it very helpful. free blackjack secret book casino gambler sport vegas free slots machine game to download desert diamond casino tucson arizona casino download free slots machine casino show windsor casino in windsor canada five play video poker arizona casino tucson barona indian casino
0.0.0.* 于 2007-03-05 22:49:10发表:
I can't wait to utilize this site even more! portable backgammon game double diamond slots machine free online casino download orleans hotel and casino in las vegas slots sphinx video best blackjack odds leather backgammon set vintage ho slots car gold strike casino resort casino sport book
0.0.0.* 于 2007-03-05 21:57:15发表:
Nice site! vegas slots online casino casino game online foxwoods mohegan sun casino station casino online sport book free on line casino slots casino chip display frame free game online slots vegas casino chip collector venetian hotel casino las vegas nv top 100 online casino
0.0.0.* 于 2007-03-05 21:21:36发表:
Your site is great no deposit free play casino blackjack internet casino seneca casino niagara falls good play roulette ways casino gamble money online win backgammon luxury set yahoo roulette game free video poker software free blackjack card northern arizona casino
64.13.227.* 于 2007-03-05 21:09:33发表:
Great site! I find it very helpful. fast money payday loan no fax required payday loan payday loan calculator fax payday loan faxless low cost payday loan advance america payday loan payday loan fast no fax low fee faxless payday loan free verizon cell phone ringtones payday loan cash advance loan
213.30.141.* 于 2007-03-05 21:08:40发表:
Great site! I find it very helpful. fast money payday loan no fax required payday loan payday loan calculator fax payday loan faxless low cost payday loan advance america payday loan payday loan fast no fax low fee faxless payday loan free verizon cell phone ringtones payday loan cash advance loan
0.0.0.* 于 2007-03-05 19:50:28发表:
My fiancee and I just moved here from out east. I just wanna tell you that we love this website! alladin hotel and casino las vegas luxor resort and casino casino consultant food palm springs area casino caesar hotel casino las vegas orleans casino las vegas arizona charlies casino baccarat free online play harrahs casino joliet casino craps table
213.41.94.* 于 2007-03-05 19:45:28发表:
Very nice website. We're glad to see that someone is making such a serious effort. Thank you! wynn casino las vegas drinking roulette game free online casino credit seminole hard rock casino hollywood fl casino code coupon free online casino consultant management mandalay bay casino in las vegas find free video poker game routed ho slots car track paragon casino resort
201.54.208.* 于 2007-03-05 19:42:26发表:
Thank you for your hard work in providing this excellent service to our wonderful worldbour!! It will be such a help to stay informed of so much that's happening. harrahs casino louisiana downs casino online recommended roulette video poker gambling foxwoods casino escort fun machine online play slots casino net search web used casino poker chips bauer slots car how to play street craps kind video slots machine
0.0.0.* 于 2007-03-05 19:38:40发表:
My fiancee and I just moved here from out east. I just wanna tell you that we love this website! roulette casino game showboat casino atlantic city nj free baccarat system black game jack snacks backgammon table casino morongo desert rain mirage hotel and casino slots car racing long island wheel of fortune slots car drag slots track
0.0.0.* 于 2007-03-05 16:33:29发表:
Beautifully crafted! baccarat computer game backgammon game for sale atlantic casino city hotel trump station casino las vegas jackpot party video slots online casino online gambling free online blackjack slots baccarat forum river palm resort casino laughlin black oak casino in california
0.0.0.* 于 2007-03-05 16:33:22发表:
Beautifully crafted! baccarat computer game backgammon game for sale atlantic casino city hotel trump station casino las vegas jackpot party video slots online casino online gambling free online blackjack slots baccarat forum river palm resort casino laughlin black oak casino in california
0.0.0.* 于 2007-03-05 16:32:12发表:
Beautifully crafted! baccarat computer game backgammon game for sale atlantic casino city hotel trump station casino las vegas jackpot party video slots online casino online gambling free online blackjack slots baccarat forum river palm resort casino laughlin black oak casino in california
0.0.0.* 于 2007-03-05 11:33:35发表:
Very useful! real time gaming casino blackjack strategy sheet computer slots machine game free online cleopatra slots argosy casino baton rouge la casino on net mac how to play craps free on line venetian resort hotel casino blackjack ballroom mississippi casino palace
0.0.0.* 于 2007-03-05 11:31:02发表:
I don't know how long it has been up and running but I just love this website! payday loan personal loan payday loan online payday loan 1 hour payday loan bad credit payday loan payday loan cash til payday loan 1 hour faxless payday loan guaranteed faxless payday loan faxless payday loan by phone
0.0.0.* 于 2007-03-05 11:30:00发表:
It's very impressive. play free blackjack top roulette casino louisiana casino and resort sands casino in atlantic city online baccarat game casino sport book top 100 online casino paris hotel and casino las vegas rtg online casino bonus code jouer au casino sur internet
0.0.0.* 于 2007-03-05 10:53:38发表:
I have already found your site to be very helpful. It is especially nice for newcomers as well as people that have been here for a while. I am sure I will come and check it often. world series of poker video game best deposit bonus casino casino gaming race wheeling casino game online play top casino download free fun game offline downloadable casino game casino video game penny casino slots paris hotel and casino in las vegas argosy casino ind
0.0.0.* 于 2007-03-05 10:45:53发表:
I am so glad you started this site. I think it's wonderful! harrahs cherokee casino hotel online penny slots gaming club online casino black game jack play free casino craps to download cyber roulette internet casino directory casino on line with no deposit bonus golden palm casino hotel casino online casino gaming
0.0.0.* 于 2007-03-05 10:45:38发表:
This is a great idea for our community and a time saver for people looking for specific things in and about the neighborhood. auto casino online play karen strip blackjack sim slots video no deposit free money casino monte carlo hotel and casino video slots game black download en jack language free casino game com blackjack picture play slots machine game
220.226.63.* 于 2007-03-05 10:41:32发表:
I don't know how long it has been up and running but I just love this website! baccarat guide free joker poker video windsor ontario casino no purchase bonus online casino slots machine software natchez mississippi casino used igt slots machine free poker casino game online playing slots machine free new casino bonus code
0.0.0.* 于 2007-03-05 10:32:07发表:
GREAT IDEA!!! Thanks and keep up the good work. blackjack casino directory casino bonus forum 50 lion machine slots video turning stone casino verona slots machine 1 32 slots car racing casino free online report sims slots free slots horseshoe casino hotel tunica free casino slots
0.0.0.* 于 2007-03-05 10:29:25发表:
I love everything about your site. baccarat online software play for fun slots machine free backgammon custom set free slots machine game to download lake charles gambling casino video poker trainer free blackjack secret poker video game x box 888 casino on net internet casino software
0.0.0.* 于 2007-03-05 10:08:10发表:
Congratulations on the Web Site. I'm sure I will visit it often. tropicana casino resort atlantic city best free online slots machine top ten online casino station casino las vegas nevada play roulette craps game download harrahs casino illinois antique slots machine for sale jackpot wheel casino casino online review uk
202.232.38.* 于 2007-03-05 09:54:04发表:
I am so glad you started this site. I think it's wonderful! casino free sands slots imperial palace hotel and casino free bonus slots game casino fl hollywood seminole casino hotel imperial las vegas thunder valley indian casino secure best online casino golden palace casino morongo casino resort baccarat crystal decanter
72.232.250.* 于 2007-03-05 08:46:35发表:
Great work!
multiplayer poker | free slot machine play | caribbean poker | virtual poker | free poker games online | free multi line slots | video slot games | bingo games | black jack game | slot machine
65.110.43.* 于 2007-03-05 08:46:17发表:
Thank you!
roulette online | internet blackjack | computer poker | play slots for fun | play poker for free | poker games free | online poker sites | casino online | star poker | monopoly slots
72.232.63.* 于 2007-03-05 08:45:48发表:
Thank you!
free slot play | free online slots no download | fun slots | free strip blackjack | casino games | online gambling sites | free poker | play casino games | online texas holdem | slots free