经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-07 20:21:27发表:
Your site is helpful. casino net casino internet online gambling jeu casino gratuit meilleur casino en ligne jeu de cartes gamme com jeu jouez ligne casino online gambling
0.0.0.* 于 2007-03-07 20:06:53发表:
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. casinos top casino en ligne roulette casinos gratuits salles de jeux jouez au casino bonus des casinos en ligne bonus des casinos en ligne casino internet casinos en ligne
0.0.0.* 于 2007-03-07 19:51:36发表:
Great site! I find it very helpful. machine sous casino on net casino en line craps casino virtuel casino partouche baccarat casino de paris jeu casino top casinos promotions
0.0.0.* 于 2007-03-07 19:46:49发表:
This is a great idea for our community and a time saver for people looking for specific things in and about the neighborhood. casinos le top des casinos en ligne casino on net online casino jouez au casino casinos jeu online jouer casino salles virtuelles de jeux gratuits top promotions en ligne
83.170.96.* 于 2007-03-07 19:27:33发表:
I don't know how long it has been up and running but I just love this website! best casino guide blackjack game rule free high play score slots win blackjack for fun station casino sports book atlantis casino game online foxwoods casino transportation baccarat crystal history yahoo casino game indian casino in southern california
0.0.0.* 于 2007-03-07 14:40:34发表:
Great work! internet baccarat game play top online casino game craps play free roulette gulfport mississippi casino free online video poker slots texas station casino slots car racing track hard rock hotel and casino las vegas grand casino gulfport mississippi seminole casino hollywood
0.0.0.* 于 2007-03-07 14:36:22发表:
Thank you. This has a great potential. play slots machine on the internet en language roulette casino slots machine trump casino gary indiana sim slots free casino chip code foxwoods casino american roulette black card counting jack mit student new casino no deposit bonus code
0.0.0.* 于 2007-03-07 14:31:54发表:
I forwarded the site to over 50 people here. ho slots car com best casino game net online blackjack net casino aero player casino game poker review tour video world casino best offer blue chip casino employment black game jack online poker video slots car racing game best casino en language online
213.240.225.* 于 2007-03-07 14:18:18发表:
My fiancee and I just moved here from out east. I just wanna tell you that we love this website! casino on net craps rules top casinos en ligne les meilleurs casinos en ligne jouez au casino baccarat jeu casino ligne le top des casinos en ligne casino de paris casino en line
0.0.0.* 于 2007-03-07 14:00:45发表:
Easy to find helpful information. indian casino gaming history building a craps table blackjack cheat sheet hollywood seattle casino play backgammon online free play price is right slots casino internet language nl slots machine slots gambling casino game guide eldon slots car
0.0.0.* 于 2007-03-07 13:52:15发表:
Please check out this website: all jackpot factory casino game roulette rule gambling blackjack roulette casino any bet casino internet casino gaming software blue chip casino employment argosy riverboat casino argosy casino in indiana buy used slots machine sim slots no download
0.0.0.* 于 2007-03-07 13:43:24发表:
Wow! I found lots of interesting things here. top rated online casino black game jack snacks horseshoe casino shreveport fitzgeralds casino tunica ms bonus free online round slots new online casino hard rock casino in las vegas casino betting line wheel of fortune slots game 888 poker tournament
0.0.0.* 于 2007-03-07 13:14:57发表:
Thank you. This has a great potential. free casino bonus to download best online blackjack slots machine slots gambling online slots 1 32 scale slots car casino jobs in tunica aladdin hotel and casino in las vegas free strip blackjack xxx free video poker strategy card online casino bonus code
0.0.0.* 于 2007-03-07 13:11:51发表:
I want to thank you for doing so much for us. What you've done for us is long overdue. casino chat free game prize the palace casino california free video poker machine free blackjack download ho scale slots car racing online casino poker rooms casino poker card atlantic city casino reservation online las vegas casino game slim slots free game
222.122.47.* 于 2007-03-07 12:51:33发表:
Excellent piece of work!! used casino poker table casino rfid chips online casino game rule ho slots car wheels gambling roulette book free nachines slots santa fe station casino planet hollywood casino free casino game win cash venetian hotel casino las vegas nv
0.0.0.* 于 2007-03-07 12:19:49发表:
I want to thank you for doing so much for us. What you've done for us is long overdue. free casino slots no download play for fun slots machine casino elkhart indiana free casino slots game for fun hard rock casino in hollywood casino online free bonus deposit stardust hotel and casino las vegas download casino slots top 20 online casino slots game jackpot party
0.0.0.* 于 2007-03-07 11:12:27发表:
We will definitely be checking in on a regular basis to see how the site is growing. free casino game online play for fun how to win at blackjack online casino bonus coupon free casino web game canadian casino directory indian game home poker use video venetian hotel and casino las vegas european roulette strategy uk baccarat decanter craps table design
0.0.0.* 于 2007-03-07 11:04:38发表:
Many thanks! roulette winning strategy keno casino online casino site craps odds european roulette online game official poker series video world play game roulette hollywood casino shreveport fitzgeralds casino las vegas gaming casino sports
0.0.0.* 于 2007-03-07 10:59:27发表:
We've needed something like this for a long-long time. Thanks for giving it to us. free slots machine secret black baccarat las vegas online casino black gambling jack online slots casino gaming link submit gambling craps backgammon download free online play lifelike slots car foxwoods casino employment nevada online casino
0.0.0.* 于 2007-03-07 10:56:07发表:
Great site! I was happy to learn about it. spa casino palm springs ca internet casino 1 casino game online virtual how to beat casino slots craps rule game poker review tour video world casino falls niagara niagara 100 free casino money blackjack card counting free bonus slots
0.0.0.* 于 2007-03-07 10:33:33发表:
You have created a wonderful site for the virtual community. Congratulations!! casino resort tunica ms best online casino site horseshoe casino hammond in blackjack internet casino chip in island casino casino on line with no deposit bonus chess and backgammon game table spa and casino hotel in palm springs best free casino bonus 888 382 1222
218.30.84.* 于 2007-03-07 10:32:17发表:
I can't wait to utilize this site even more! best casino chicago price casino poker card best casino online pay slots game jackpot party arizona casino in party rental bonus game slots online casino free code line casino bonus free cash casino black casino game jack roulette
0.0.0.* 于 2007-03-07 10:10:55发表:
Your site is helpful. harrahs casino reno winstar casino oklahoma backgammon back door free casinos gaming roulette table play baccarat free yahoo backgammon game gambling blackjack software caesars casino indiana palace no download no deposit casino bonus
72.232.250.* 于 2007-03-07 09:27:34发表:
Thank you!
free casinos | play free roulette | free online bingo | free online roulette | games on line | poker | play poker | free fun slots | strip blackjack | free casino slots
65.110.43.* 于 2007-03-07 09:26:56发表:
Great work!
casino games free | free casino downloads | free online poker games | download free poker games | cleopatra slot machine | slots on line | play texas holdem | free money no deposit casinos | strip blackjack game | us poker sites
65.110.43.* 于 2007-03-07 09:26:35发表:
Thank you!
free online casino | casino games online | pokerstars download | free blackjack | blackjack online free | internet casino | play roulette for free | free video poker | absolute poker | slim slots free
65.110.43.* 于 2007-03-07 09:26:19发表:
Nice site!
internet casinos | free internet poker | monopoly slots | poker on line | free online slot machine games | free roulette online | free online casino slots | free slots games | poker usa | online gambling sites
72.232.63.* 于 2007-03-07 09:26:07发表:
Good design!
casino bonuses | slot machine | free poker downloads | texas holdem | texas holdem free | download casino games | free slot machine games online | free online slots no download | free black jack | free slim slots
0.0.0.* 于 2007-03-07 09:24:31发表:
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. download casino slots slim slots game ameristar casino council bluff win baccarat fly slots car bingo casino foxwoods info remember chukchansi gold resort and casino ballys hotel and casino learn to play blackjack free argosy casino in indiana lawrenceburg
0.0.0.* 于 2007-03-07 09:06:57发表:
Your site is great casino windsor jobs james bond casino royale baccarat decanter play free slim slots harrahs casino atlantic city free internet slots game station casino in las vegas wild cherry slots sims free slots game free slots machine strategy
0.0.0.* 于 2007-03-07 08:23:34发表:
Great site! I was happy to learn about it. hard rock casino hollywood casino en gambling internet language blackjack roulette online 0n casino net play for free casino slots game handheld casino game casino club palm rain casino foxwoods restaurant casino in palm springs california lauberge du lac casino lake charles
0.0.0.* 于 2007-03-07 06:21:25发表:
Cool website! build a roulette wheel backgammon game piece game king machine slots free video blackjack casino hotel in lake charles la frog prince slots online free online casino free advertising free online casino credit direction to foxwoods casino craps tip
89.34.9.* 于 2007-03-07 04:02:07发表:
Great site! I find it very helpful. mandalay bay resort casino las vegas download free haywire machine slots casino net popup slots machine for sale on tv best gambling online blackjack multi player casino casino hotel best 900 pay online casino add casino gaming site cannery casino hotel
0.0.0.* 于 2007-03-07 03:44:12发表:
Amazing site! xxx video poker strip blackjack poker table tropicana casino playing card black casino en jack language free money on line casino online backgammon game casino slots for fun casino job niagara seneca backgammon game set casino girl palm
0.0.0.* 于 2007-03-07 03:41:37发表:
It is very informative easily navigated and attractive. slots car racing set indiana argosy hotel casino casino en language online terribles hotel and casino las vegas internet baccarat game best online casino directory 21 black free jack play casino stockton california keno game roulette
0.0.0.* 于 2007-03-07 03:18:14发表:
You are the best! casino rama package free online video poker bonus chumash indian casino black free jack playing free video poker game on line free video poker software blackjack pizza colorado tunica missippi casino bonus fun play slots palm casino las vegas
0.0.0.* 于 2007-03-07 02:24:32发表:
GREAT IDEA!!! Thanks and keep up the good work. wooden backgammon set casino free offline slots casino on net mac free on line slots free blackjack tournament morongo casino concert google slots game web casino roulette black game jack online play free fun slots
0.0.0.* 于 2007-03-07 00:01:48发表:
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. in door mail slots 1 32 slots car set plaza hotel and casino las vegas best casino online poker video play casino slots black craps jack poker roulette casino game software free money no play slots best online casino sports betting tunica casino entertainment
0.0.0.* 于 2007-03-06 23:57:46发表:
I enjoyed the visit! rule for playing craps black casino cheat jack online no deposit casino redeem coupon winstar casino and hotel casino hotel real time gaming casino online penny slots las vegas slots machine online 2006 casino movie royale baccarat buyer crystal
0.0.0.* 于 2007-03-06 23:38:40发表:
It's very exciting!! on line video poker game atlantic city nj casino game roulette rule casino gaming machine niagara casino rooms barona casino california casino indiana northern play sim slots free casino en language roulette gambling gaming casino