经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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 23:29:53发表:
Good work. casino in arizona gold strike casino in tunica black en jack language rule internet casino gambling game bingo casino station charlestown slots free play prize slots horseshoe casino hotel tunica harrahs casino in kansas city casino nj resort tropicana
0.0.0.* 于 2007-03-06 22:58:35发表:
Nice site man! harrahs casino omaha las vegas resort casino baccarat software bingo casino info internet remember video clip of strip poker fitzgeralds casino tunica mississippi casino free listing online z free casino no download or deposit gambling tip blackjack to earn cash to play online casino
0.0.0.* 于 2007-03-06 22:51:34发表:
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! no fax needed payday loan easy online payday loan payday loan quick cash payday loan real music ringtones ringtones fast auto and payday loan private no fax payday loan online payday loan no faxing payday loan on line california payday loan
0.0.0.* 于 2007-03-06 22:37:20发表:
It is very informative easily navigated and attractive. travel backgammon online flash casino play for free offline blackjack casino craps blackjack casino game en game language machine slots online slots game blackjack play rule hard rock seminole casino fl tip for win at blackjack
0.0.0.* 于 2007-03-06 22:15:19发表:
We will definitely be checking in on a regular basis to see how the site is growing. foxwoods casino poker new york hotel and casino harrahs east chicago casino hotel casino game online thunderstruck game leprechaun slots video plaza hotel and casino las vegas horseshoe casino hotel tunica ms scorchy slots learn how to play casino game casino line game
0.0.0.* 于 2007-03-06 21:55:55发表:
I forwarded the site to over 50 people here. casino hotel in las mgm vegas how to win at roulette free en language poker video paris hotel and casino las vegas download free game slots video official blackjack rule casino download free game no slots casino royale vegas casino getaway in atlantic city roulette table
0.0.0.* 于 2007-03-06 20:26:05发表:
The site is easy to use and very helpful. Thank you for this wonderful service. I am recommending it to everyone. free slots machine free trial craps dice game rule california casino harrahs in chumash casino resort san diego california casino free computer casino game used craps table best game poker rated video free baccarat game free super slots
0.0.0.* 于 2007-03-06 20:26:00发表:
I just wanted you to know how much I appreciate your support. craps table plan blackjack web casino station casino in las vegas casino new niagara york tuscany hotel and casino las vegas cash casino deposit no required black free jack playing casino map niagara pala indian casino hollywood casino in shreveport la
0.0.0.* 于 2007-03-06 19:26:06发表:
It's very impressive. 777 free at carnival casino bonus casino free online roulette rtg casino no deposit bonus casino poker game online web site baccarat the internet casino craps practice table no deposit flash casino baccarat crystal vase casino morongo night club revell slots car
0.0.0.* 于 2007-03-06 19:08:10发表:
I want to thank you for doing so much for us. What you've done for us is long overdue. niagara falls new york casino how to play backgammon game horseshoe casino in bossier city stardust hotel and casino las vegas hotel near turning stone casino las vegas casino poker tournament backgammon empire online casino game for macintosh free craps game casino world series of poker video game
0.0.0.* 于 2007-03-06 18:43:37发表:
It is very informative easily navigated and attractive. casino code coupon deposit no online online blackjack for fun harrahs cherokee casino hotel blackjack strategy guide free joker poker video stardust casino betting line blackjack game table find free video poker game rule for playing backgammon casino code coupon free online
213.180.140.* 于 2007-03-06 15:48:05发表:
I enjoyed the visit! blackjack table layout slots machine cheat casino niagara transportation sterling casino line atlantic city casino reservation game poker review series video world other game baccarat casino chip free nd free no deposit casino casino online free bonus deposit
83.12.94.* 于 2007-03-06 14:49:10发表:
It's very exciting!! band casino harrahs prairie winner las vegas blackjack play free slots for fun play for fun free casino download pc poker strip video black i jack online belle terra casino indiana game video game recreation dice craps mgm grand casino las vegas casino gambling gaming online slots
0.0.0.* 于 2007-03-06 10:29:19发表:
Great site! I find it very helpful. learn to play video poker sandia resort and casino craps system 9 line video slots game home poker use video how to play street craps hollywood casino mississippi ameristar casino hotel casino betting line msn backgammon
158.144.44.* 于 2007-03-06 10:22:56发表:
I forwarded the site to over 50 people here. top 100 online casino free video poker tutor vegas video poker free flush fortune video poker book casino deposit maker no poker cash creek indian casino casino hard hotel joint rock free craps game download online poker strategy video play free video slots online
0.0.0.* 于 2007-03-06 10:19:17发表:
Great site! I was happy to learn about it. play for free fun slots casino ho slots car com niagara falls new york casino cash casino deposit free no site backgammon custom set no deposit no download casino gambling roulette tip new louisiana casino casino download free game no slots free sim slots online
220.226.63.* 于 2007-03-06 10:18:26发表:
Hi! Love your site.. Looks really amazing compared even to the best pages on the Web ever! jackpot casino online free blackjack tournament casino free online pin royal vegas palm casino maloof ca casino pechanga casino cruise west palm beach buffalo bills hotel and casino online roulette table tunica casino employment williams slots machine for sale
125.90.64.* 于 2007-03-06 09:44:43发表:
The site is easy to use and very helpful. Thank you for this wonderful service. I am recommending it to everyone. mississippi casino resort pala casino san diego ca blackjack tournament strategy free ware video poker casino hotel in lake charles la slots machine part mandalay bay resort hotel and casino no deposit sign up bonus online casino dealer school casino california roulette layout
72.232.250.* 于 2007-03-06 09:33:41发表:
Thank you!
poker bonus | free on line poker | online casinos | play free blackjack online | free casino | video slot machine | no download slots | poker online | free strip black jack | free bingo
72.232.250.* 于 2007-03-06 09:32:44发表:
Great work!
video poker free | free monopoly online | poker for free | free slots | free play slot machines | free blackjack game | no deposit bonuses | online poker usa | online blackjack free | free poker websites
72.232.250.* 于 2007-03-06 09:32:21发表:
Great work!
free online slots no downloads | slot games | texas hold em poker | free slot machine game | poker games | slot machines | free slot play | bingo games | world series of poker | free online poker game
72.232.250.* 于 2007-03-06 09:32:00发表:
Great work!
online casino | texas holdem free online | new online casinos | no download free slots | free online strip blackjack | video poker machines | slot machines games | play roulette online | casino slots | poker free
72.232.63.* 于 2007-03-06 09:31:51发表:
Great work!
play free slots | online roulette | black jack online | casinos online | blackjack online free | poker games online | black jack download | free slot machine | free poker software | free online blackjack
213.240.225.* 于 2007-03-06 09:28:29发表:
Thanks for letting me know about this site. Thanks again!! affiliate best casino program ten world net jackpot casino el dorado hotel and casino blackjack poker rule downloadable blackjack game casino download en language bingo casino virtual mcphillips street station casino super slots casino atlantic city new jersey casino
0.0.0.* 于 2007-03-06 09:23:47发表:
We will definitely be checking in on a regular basis to see how the site is growing. casino city harrahs kansas north car nascar racing slots pechanga casino temecula how to build a blackjack table grand casino tunica ms grand casino tunica miss top online casino bonus handheld video poker game blackjack video game play blackjack no download
211.116.133.* 于 2007-03-06 09:21:38发表:
Thank you for helping us! free backgammon game atlantic casino tropicana home slots machine for sale casino craps gambling real time gaming casino best online casino site bonus casino deposit from no online casino promotion no deposit blackjack card counting strategy free no downloading casino game
0.0.0.* 于 2007-03-06 09:04:42发表:
This is a great idea for our community and a time saver for people looking for specific things in and about the neighborhood. video poker tip bonus casino code nd online rtg online roulette site black electronic game jack ameristar casino hotel council bluff harrahs casino cherokee nc no download free slots game casino slots web sandia resort and casino casino direction stone turning
0.0.0.* 于 2007-03-06 08:52:28发表:
Cool website! casino juegos line blackjack rule uk free roulette betting system casino lula mississippi free gambling money for online casino arnie play roulette russian uncle casino rama orillia baccarat message new post free 5 slots reel online internet slots
0.0.0.* 于 2007-03-06 08:26:58发表:
It is very informative easily navigated and attractive. stardust hotel and casino las vegas play united casino on line casino gaming online casino three card poker jelly fish backgammon hard rock seminole casino fl play internet blackjack atlantic city casino reservation pala casino ca rule for playing blackjack
0.0.0.* 于 2007-03-06 04:30:34发表:
Many thanks! download casino slots blackjack table online casino palm casino resort las vegas learning craps winstar casino in oklahoma harrahs casino in indiana palm spring casino online casino coupon code free cash best rated internet casino affiliate casino internet online
0.0.0.* 于 2007-03-06 04:06:53发表:
Keep up the great work. Keep it up! used slots machine for sale learning to play craps baccarat crystal aol free casino game direction to casino morongo foxwoods casino gold strike casino tunica 101 best online casino mail box slots rule to play backgammon
213.240.225.* 于 2007-03-06 03:44:35发表:
Great work! backgammon game piece stardust resort and casino caribbean casino internet poker stud blackjack pizza colorado internet casino gaming best 900 pay online casino craps strategy best roulette casino turning stone casino showroom casino in mississippi open
0.0.0.* 于 2007-03-06 03:33:05发表:
It's very impressive. blackjack odds chart internet craps game cannery casino las vegas learning craps isle of capri casino hotel rental roulette wheel casino line orbital free fun play poker video slots car track in connecticut best neteller online casino
0.0.0.* 于 2007-03-06 03:22:14发表:
I just wanted you to know how much I appreciate your support. blue chip casino employment best online sports casino to bet flash online casino game argosy casino ind blackjack for fun mit blackjack team free pc slots game blackjack slots machine gambling resort casino atlantic city casino royale hotel
0.0.0.* 于 2007-03-06 03:20:41发表:
Looks good. casino com free game slots boom casino harvey louisiana town casino flash online palm vegas discount casino hotel las vegas online slot strong play casino slots palace station hotel and casino casino play online poker for fun play free video poker hard rock casino vegas
0.0.0.* 于 2007-03-06 02:42:04发表:
This site is wonderful. online casino play money video poker betting affiliate casino directory free harrahs casino laughlin nevada winning craps system foxwoods casino life like slots car casino in northern california wisconsin indian casino casino casino game online poker
200.59.145.* 于 2007-03-06 02:41:56发表:
This site is wonderful. online casino play money video poker betting affiliate casino directory free harrahs casino laughlin nevada winning craps system foxwoods casino life like slots car casino in northern california wisconsin indian casino casino casino game online poker
0.0.0.* 于 2007-03-06 02:00:36发表:
I will recommend it! foxwoods casino address five play video poker casino affiliate program directory free blackjack system casino indiana northern five play video poker casino las vegas on line play baccarat play blackjack no download sands hotel and casino
0.0.0.* 于 2007-03-06 01:56:59发表:
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. free roulette professional system baccarat forum blue chip casino indiana no deposit casino coupon code black electronic game jack playing blackjack mail slots cover online casino gambling sports betting gambling roulette book free casino cash no deposit required
158.144.44.* 于 2007-03-06 01:41:39发表:
You are the best! casino deposit download new no no free poker practice video baccarat perfume bottle casino en francais video strip poker 2 cheat play free roulette game video strip poker full online casino gambling world series of poker ps2 video game 21 black game jack