经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.232.63.* 于 2007-03-05 08:45:17发表:
Well done!
casinos online | slot machines games | on line poker | on line gambling | texas holdem online | blackjack online free | slots on line | slots download | free casino online | cleopatra slots
72.232.250.* 于 2007-03-05 08:44:50发表:
Nice site!
internet casinos | free slot machine downloads | free casino downloads | free money no deposit | sim slots | no download slots | roulette free | texas holdem | texas poker | strip black jack
0.0.0.* 于 2007-03-05 05:15:51发表:
I enjoyed the visit! casino chip poker supply free casino game top recommended link new no deposit casino coupon download free game slots video wynn hotel casino in las vegas gambling roulette book braid car need slots track track casino il island metropolis player baccarat crystal decanters blackjack mountain
0.0.0.* 于 2007-03-05 04:02:01发表:
Easy to find helpful information. bonus casino code guide play craps for money online keno atlantic city casino rooms roulette system forum las vegas casino slots machine craps casino near palm springs new casino bonus code luxor hotel and casino las vegas
0.0.0.* 于 2007-03-05 03:39:41发表:
I just wanted you to know how much I appreciate your support. casino player information baccarat glass game leprechaun slots video online casinos rain at palm casino hotel next to casino niagara video poker site cash casino red deer black free jack online strong free online slots machine
0.0.0.* 于 2007-03-05 03:39:12发表:
This is a great idea for our community and a time saver for people looking for specific things in and about the neighborhood. sim slots no download blue water casino parker arizona free blackjack system strip video poker girl northern california casino craps littlewoods online las vegas casino wedding pala casino resort and spa game home poker use video sands hotel and casino atlantic city
213.195.153.* 于 2007-03-05 03:35:55发表:
You have created a wonderful site for the virtual community. Congratulations!! barona indian casino casino elkhart indiana play free casino game 39 arizona casino charlie hotel s free video poker slots casino gaming net casino free money play hotel casino in atlantic city new casino online no deposit bonus roulette strategy
0.0.0.* 于 2007-03-05 03:14:26发表:
Very useful! blackjack table rental black game jack v66i casino game online virtual free winning roulette system las vegas club hotel casino free slim slots machine indian casino in northern california life like slots car track blackjack pizza coupon casino exchange gaming link
168.243.11.* 于 2007-03-05 02:48:58发表:
I was very impressed with how professional your site is. bellagio casino las vegas venetian hotel casino las vegas nv state line nevada casino blackjack pershing best free online casino game slots car racing magazine wheel of fortune slots bodog book casino sport grand casino coushatta louisiana free baccarat system
0.0.0.* 于 2007-03-05 02:48:23发表:
I just wanted you to know how much I appreciate your support. learn how to play casino game free online casino download neteller online casino joker wild video poker turning stone casino verona comfort machine sale slots best online casino poker review free gambling slots online las vegas casino game online progressive slots video
0.0.0.* 于 2007-03-05 02:43:23发表:
I will recommend it! 1 card casino game cleopatra video slots machine harrahs casino shreveport louisiana wheel of fortune slots machine resort casino atlantic city online bingo free adult casino game baccarat the internet casino game blackjack game for fun used craps table
208.254.9.* 于 2007-03-05 02:42:22发表:
I was very impressed with how professional your site is. bellagio casino las vegas venetian hotel casino las vegas nv state line nevada casino blackjack pershing best free online casino game slots car racing magazine wheel of fortune slots bodog book casino sport grand casino coushatta louisiana free baccarat system
213.240.225.* 于 2007-03-05 02:38:47发表:
keno portal internet keno portal internet http://www.free-hoster.cc/users/casinoenlinea/keno-3.html free alltel ringtones http://freesprintringtones.t35.com/ringtones-2.html ringtones converter download free ringtones t mobile free verizon wireless ringtones http://www.gwebspace.de/proringtones/free-ringtones-3.html http://pokerenlinea.freewebpages.org/casino-internacional-3.html casino internacional portal web casino internacional portal internet pai gow poker pai gow poker pagina internet http://pokerenlinea.freewebpages.org/pai-gow-2.html internet casino casino ligne http://www.gwebspace.de/pokergr/online-casino-1.html http://www.gwebspace.de/freeringtonez/ringtone-4.html free nextel ringtone depeche mode ringtone lose yourself ringtones http://freeringtonez.iespana.es/ringtones-4.html lose yourself ringtones baccarat paginas internet baccarat web http://www.free-hoster.cc/users/casinoenlinea/baccarat-2.html kostenloses online poker spiel http://freieronlinepoker.t35.com/online-poker-3.html kostenloses online poker spiel
213.240.225.* 于 2007-03-05 02:28:56发表:
Many thanks! payday loan kansas online payday loan easy no faxing payday loan application low fee faxless payday loan best payday loan company cash america payday loan no bank statement payday loan payday loan company online jennifer lopez ringtone free phone ringtones
85.91.80.* 于 2007-03-05 02:17:17发表:
Wow! I found lots of interesting things here. low interest payday loan easy no fax payday loan payday loan absolutely no fax payday loan cash till payday loan salt lake payday loan personal no fax payday loan no fax payday loan today cash til payday loan fast auto and payday loan
0.0.0.* 于 2007-03-05 02:16:45发表:
Wow! I found lots of interesting things here. low interest payday loan easy no fax payday loan payday loan absolutely no fax payday loan cash till payday loan salt lake payday loan personal no fax payday loan no fax payday loan today cash til payday loan fast auto and payday loan
0.0.0.* 于 2007-03-05 01:19:50发表:
I can't wait to utilize this site even more! free casino card game download no download casino pala casino bellagio hotel and casino play free slots game lifelike ho slots car download game no poker video bonus casino deposit no signup new online casino slots fallsview casino canada
0.0.0.* 于 2007-03-05 00:44:01发表:
Hi! Love your site.. Looks really amazing compared even to the best pages on the Web ever! casino empire download play free blackjack game casino rama event ameristar casino in kansas city blackjack basic rule casino chip display casino bonus directory free online cleopatra slots pc free download casino game casino to play offline
0.0.0.* 于 2007-03-05 00:33:30发表:
Many thanks! secure best online casino amp ca casino pechanga resort temecula rule for playing craps blackjack table plan slots car free online game download free casino slots game golden palace casino casino game internet casino casino free sands slots online casino casino gambling poker
0.0.0.* 于 2007-03-05 00:31:45发表:
It's very exciting!! harrahs casino kansas fortune free game slots video wheel no deposit bingo casino online slots play offline car ho layout scale slots track harrahs casino missouri ameristar casino ms vicksburg 3 free machine reel slots atlantic borgata casino city hotel in casino falls hotel niagara view
212.11.0.* 于 2007-03-05 00:12:37发表:
I am so glad you started this site. I think it's wonderful! foxwoods casino address casino in california casino download fun game no best casino casino dummy slots machine token casino las vegas nevada free money for casino slots spa resort casino free cash casino free cash no download no deposit casino
0.0.0.* 于 2007-03-04 23:45:21发表:
Your web site is really helpful! Clean and loaded with info. baccarat rule roulette casino arizona baccarat stemware video strip poker download quinault beach resort and casino free keno poker strip torquemada video cash casino deposit no required backgammon game online play oklahoma indian casino
0.0.0.* 于 2007-03-04 23:44:09发表:
I wish you the best of luck the site is really great and if there is anything my organization can do to help you make it even more informative please let me know. atlantic city boardwalk casino golden nugget hotel and casino harrahs cherokee casino best casino online payouts baccarat crystal angel play free roulette bingo casino virtual caesars indiana casino hotel orleans casino las vegas fair machine play slots
0.0.0.* 于 2007-03-04 23:05:00发表:
Wow! I found lots of interesting things here. winning blackjack casino craps free play poker casino chip colors monopoly slots machine game hollywood casino shreveport la casino empire download craps odds blackjack table kit louisiana gambling casino the quarter at the tropicana casino
0.0.0.* 于 2007-03-04 23:04:11发表:
Nice site man! harrahs casino com play slots 1 32 scale slots car crazy vegas casino casino neteller online top casino hotel near niagara harrahs casino in kansas city 5000 best online casino casino hotel in lake charles la start your own online casino for free
0.0.0.* 于 2007-03-04 22:32:51发表:
It's very exciting!! blackjack poker rule free casino slots game for fun mgm grand hotel and casino resort in indiana casino indian casino in southern california best western mardi gras hotel casino new casino in niagara falls belterra hotel and casino indiana casino blackjack game online palace station hotel and casino
0.0.0.* 于 2007-03-04 16:19:08发表:
lone star ringtone verizon wireless ringtone http://cellpringtonez.prophp.org/ringtone-4.html online roulette roulette online http://stanzedapo01.php0h.com/roulette-1.html caribbean stud poker poker caribe paginas web http://casinoenlinea3.netfast.org/caribbean-poker-1.html maquinas tragaperras portal maquinas tragaperras portales http://www.leaguelineup.com/casinoenlinea/files/maquinas-tragaperras-3.html pai gow poker web http://pokerenlinea.freewebpages.org/pai-gow-4.html pai gow poker portales http://casinoenlinea.xlphp.net/caribbean-poker-3.html poker caribe portales web caribbean poker portales juegos azar portales juegos de azar http://pokerenlinea.freewebpages.org/juegos-azar-2.html casino fran?is http://jeupokerlig.php0h.com/casino-2.html banque casino ruleta portales internet tambor ruleta http://casinoenlinea.xlphp.net/roulette-3.html juego seguro juegos gratis para bajar http://www.leaguelineup.com/casinoenlinea/files/juego-2.html
65.110.43.* 于 2007-03-04 09:13:17发表:
Nice site!
casino download | absolute poker | free texas hold em | free slots | bonus poker | free multi line slots | free play slots | free bingo games | free poker downloads | free blackjack games
72.232.250.* 于 2007-03-04 09:12:59发表:
Great work!
casino slot games | aussie slots | free bingo online | free video poker | new no deposit online casinos | casino games | no deposit casino | no deposit bingo | free slot | free online slots
65.110.43.* 于 2007-03-04 09:12:15发表:
Great work!
free casino slot games | free texas holdem | russian roulette game | world poker | slots online | free poker software | play blackjack online | free strip blackjack | free online slots no download | new online casinos
72.232.250.* 于 2007-03-04 09:11:11发表:
Great work!
free slots download | games on line | slots of fun | poker game online | poker online | roulette free | online blackjack free | internet gambling | online free roulette | free roulette
72.232.250.* 于 2007-03-04 09:11:11发表:
Great work!
free slots download | games on line | slots of fun | poker game online | poker online | roulette free | online blackjack free | internet gambling | online free roulette | free roulette
72.232.63.* 于 2007-03-04 09:11:06发表:
Good design!
slot machines | free slot machines games | sims slots | online slot machines | free texas holdem online | online free blackjack | blackjack download | free black jack | strip blackjack | casino on line
0.0.0.* 于 2007-03-04 06:37:55发表:
Great site! I was happy to learn about it. loan til payday canadian payday loan mp3 ringtone personal debt consolidation paradise poker adipex online blackjack gambling payday loan las vegas debt consolidation credit counseling free online craps
0.0.0.* 于 2007-03-04 06:17:58发表:
I will bookmark! fast cash payday loan online no fax payday loan paradise poker loan til payday world poker tour free penis enlargement mp3 ringtone las vegas casino adipex online buy fioricet online
200.59.145.* 于 2007-03-04 06:16:31发表:
I just wanted you to know how much I appreciate your support. poker card unsecured debt consolidation canadian payday loan caribbean poker online internet casino game paradise poker online no fax payday loan las vegas online casino play free roulette mp3 ringtone
0.0.0.* 于 2007-03-04 06:16:27发表:
I just wanted you to know how much I appreciate your support. poker card unsecured debt consolidation canadian payday loan caribbean poker online internet casino game paradise poker online no fax payday loan las vegas online casino play free roulette mp3 ringtone
0.0.0.* 于 2007-03-03 23:10:55发表:
I forwarded the site to over 50 people here. add bonus casino url free on line casino cash best bonus casino deposit no online casino francais casino in palm springs california argosy casino mo riverside bonus casino deposit flash no hollywood seattle casino blackjack ballroom car drag slots track
0.0.0.* 于 2007-03-03 19:29:57发表:
Please check out this website: vegas red casino best casino gambling free online video poker bonus soaring eagle casino entertainment free internet slots game slots game for fun no deposit casino offer european roulette rule casino blackjack strategy game glass roulette shot
201.13.217.* 于 2007-03-03 18:39:09发表:
I am so glad you started this site. I think it's wonderful! all jackpot factory casino spa and casino hotel in palm springs casino bonus code hard rock hotel and casino tampa fl argosy casino missouri online penny slots online slots slots machine down roulette system tab harrahs casino jobs noble game backgammon