经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.36.211.* 于 2007-07-31 21:16:15发表:
Well done!
motorola keypress ringtones | cellular south ringtones | cellphone ringtones | wav ringtones | free polyphonic | ringtones for nokia | ringtones for us cellular | sprint pcs ringtones | ringtones cingular | real klingelton
72.36.211.* 于 2007-07-31 21:15:48发表:
Thank you!
cep melodi | ring tones | free ringtones for u s cellular | nextel ringtone program | simpsons ringtone | christian ringtones | free cingular ringtones | rihanna ringtones | free ringtones for tmobile | ringtones for motorola
72.36.211.* 于 2007-07-31 21:14:52发表:
Great work!
free ringtones downloads | free centennial wireless ringtones | free composer ringtones | sonneries telephone | suonerie cellulare gratis | cisco ringtones | gwen stefani ringtones | ringtones for tracfone | toques samsung | funny ringtones
72.36.211.* 于 2007-07-31 21:14:16发表:
Well done!
free ringtones us cellular | dzwonek mp3 | free mobile downloads | nextel ringtone | darmowe dzwonki | free phone ringtones | tonos samsung | bedava melodi | free downloadable t mobile ringtones | country ringtones
72.36.211.* 于 2007-07-31 21:14:02发表:
Nice site!
mobiel ringtone | free anime | downloadable ringtones | ringtones midi | motorola ringtones | free ringtone creator | online ringtone converter | free downloadable ringtones | free ringtones for motorola | handy klingelton
60.177.54.* 于 2007-07-31 17:27:59发表:
cheapest ffxi gil。。
cheapest ffxi gil。。
cheap wow powerleveling。。
cheap wow powerleveling。。
cheap wow Powerleveling。。
cheap wow power leveling。。
cheap wow gold。。
cheap wow gold。。
cheap wow gold 。。
cheap wow gold。。
cheap wow gold。。
cheap world of warcraft gold。。
cheap world of warcraft gold。。
cheap world of warcraft gold。。
Cheap world of warcraft gold。。
cheap Vanguard Gold。。
cheap Vanguard gold。。
cheap Vanguard Gold。。
cheap swg credits。。
cheap power leveling。。
cheap maple story mesos。。
cheap maple story meso。。
cheap lotro gold。。
cheap lineage 2 adena。。
cheap lineage 2 adena。。
cheap L2 adena。。
cheap gw gold。。
cheap Guild Wars gold。。
cheap gold wow。。
cheap gold wow。。
60.176.195.* 于 2007-07-31 06:15:03发表:
cheapest ffxi gil。。
cheapest ffxi gil。。
cheap wow powerleveling。。
cheap wow powerleveling。。
cheap wow Powerleveling。。
cheap wow power leveling。。
cheap wow gold。。
cheap wow gold。。
cheap wow gold 。。
cheap wow gold。。
cheap wow gold。。
cheap world of warcraft gold。。
cheap world of warcraft gold。。
cheap world of warcraft gold。。
Cheap world of warcraft gold。。
cheap Vanguard Gold。。
cheap Vanguard gold。。
cheap Vanguard Gold。。
cheap swg credits。。
cheap power leveling。。
cheap maple story mesos。。
cheap maple story meso。。
cheap lotro gold。。
cheap lineage 2 adena。。
cheap lineage 2 adena。。
cheap L2 adena。。
cheap gw gold。。
cheap Guild Wars gold。。
cheap gold wow。。
cheap gold wow。。
203.121.69.* 于 2007-07-31 01:57:29发表:
Hi, my Best free mp3 music downloads site: :
free music downloads = free music = music downloads = music = free mp3 downloads = music download = free music download = download music free = download music for free =
http://www.fixgrout.com/cgi/ free music downloads :: http://www.fixgrout.com/cgi/musicpage1.html free music :: http://www.fixgrout.com/cgi/musicpage2.html music downloads :: http://www.fixgrout.com/cgi/musicpage3.html music :: http://www.fixgrout.com/cgi/musicpage4.html free mp3 downloads :: http://www.fixgrout.com/cgi/musicpage5.html music download :: http://www.fixgrout.com/cgi/musicpage6.html free music download :: http://www.fixgrout.com/cgi/musicpage7.html download music free :: http://www.fixgrout.com/cgi/musicpage8.html download music for free :: http://www.fixgrout.com/cgi/musicpage9.html free download music :: http://www.fixgrout.com/cgi/musicpage10.html download music video ::
free music downloads .. free music .. music downloads .. music .. free mp3 downloads .. music download .. free music download ..
72.36.211.* 于 2007-07-30 12:16:20发表:
Thank you!
strip blackjack online | empire poker | black jack games | blackjack game | slim slots | free slot play | slot games | casino on line | on line gambling | play poker for free
72.36.211.* 于 2007-07-30 12:15:19发表:
Great work!
new free money online casinos | casino free | casino bonuses | texas holdem | download free poker game | poker for fun | poker game free | bingo vega | internet casino games | online texas holdem
72.36.211.* 于 2007-07-30 12:14:45发表:
Well done!
internet poker | slot machines free | free poker money | world poker | free slots for fun | free slot games | texas holdem free online | free slots no download | bingo gala | free slot machines online
72.36.211.* 于 2007-07-30 12:14:35发表:
Good design!
gambling sites | star poker | casino download | playing bingo | casinos online | download blackjack | play bingo for free | on line poker | poker on line | free casino bonus
72.36.211.* 于 2007-07-28 21:57:49发表:
Nice site!
free games online | online roulette game | play black jack | empire poker | world series of poker | online free slots | blackjack for free | internet casino | free slot | free slot games online
72.36.211.* 于 2007-07-28 21:57:23发表:
Well done!
online casinos | free sim slots | download casino | free casino games | free blackjack games | download free poker game | roulette free games | play money poker | poker games | pokerstars download
72.36.211.* 于 2007-07-28 21:56:23发表:
Well done!
free online bingo | free online slot machine | free play slots | bonus casino free online | online slots free | virtual poker | texas holdem free | casino free games | free slots | download poker
72.36.211.* 于 2007-07-28 21:56:04发表:
Well done!
texas poker | russian roulette | free no deposit casinos | poker game online | play texas holdem online | online baccarat | free casino cash | online roulette free | gambling machines | free blackjack online
72.36.211.* 于 2007-07-28 21:55:53发表:
Nice site!
free online bingo games | casino slots | online poker game | internet bingo | poker for fun | star poker | online games | no deposit bingo | free slots download | game slot
65.211.3.* 于 2007-07-27 23:18:32发表:
box cigarette filter light marlboro white box cigarette filter light marlboro white http://www.123giftwrap.info/box-cigarette-filter-light-marlboro-white.html composition bouquet composition bouquet http://www.1-fr-flower.info/forum/1153 christmas gift idea for mom christmas gift idea for mom http://www.1baby-gift-de.info/article/1671.asp flower in photo picture vase flower in photo picture vase http://www.1send-flowers.info/1509 power of attorney template power of attorney template http://www.de-law-attorney.info/files/power-of-attorney-template fiera articolo regalo new delhi fiera articolo regalo new delhi http://www.it-gift-basket.info/fiera-articolo-regalo-new-delhi proper wedding anniversary gift proper wedding anniversary gift http://www.1geschenkidee.info/files/proper-wedding-anniversary-gift.asp employment law employment law http://www.german-law-1.info/tag/1094.php coffret fleurs de bach coffret fleurs de bach http://www.wedding-flowers-fr.info/news/coffret-fleurs-de-bach.html llama abogado juana chaos llama abogado juana chaos http://www.1ley-es.info/7/llama-abogado-juana-chaos.asp
79.113.5.* 于 2007-07-27 22:40:07发表:
bride bouquet bride bouquet http://www.1-flowerses.info/ads/bride-bouquet gadgets blog gadgets blog http://www.es-gift-baskets.info/docs/gadgets-blog.html bouquet bridal canada flower fresh bouquet bridal canada flower fresh http://www.1-wedding-flowers.info/articles/bouquet-bridal-canada-flower-fresh red and orange flower red and orange flower http://www.silk-flowers-1.info/cat/1772.html cadeaux massage femme cadeaux massage femme http://www.1idee-cadeaux.info/cadeaux-massage-femme.asp bed box in tool truck bed box in tool truck http://www.1-giftbaskets.info/2006/1904.php abuse carolina home lawyer nursing south abuse carolina home lawyer nursing south http://www.1-law-school.info/1872.html una planta hidro electrica una planta hidro electrica http://www.flor-artificial-es.info/today/1510 card credit credit rebuilding unsecured card credit credit rebuilding unsecured http://www.1personal-loan.info/card-credit-credit-rebuilding-unsecured.html contrat juridique contrat juridique http://www.law-attorney-fr.info/phorum/contrat-juridique.php
0.0.0.* 于 2007-07-27 21:17:49发表:
michigan seed company michigan seed company http://www.flowers-online-1.info/files/1469.html mortgage national protection mortgage national protection http://www.1online-loan.info/post/mortgage-national-protection pietra vulcanica giardino pietra vulcanica giardino http://www.1-fiori.info/6/pietra-vulcanica-giardino.asp fiore rosa malattia fiore rosa malattia http://www.vendita-fiori.info/files/fiore-rosa-malattia.php 30th birthday gift 30th birthday gift http://www.giftgadgets-de.info/30th-birthday-gift.asp b abogado 28001 madrid madrid espana b abogado 28001 madrid madrid espana http://www.es-ley-abogado.info/articles/1751.asp easy to make valentine gift easy to make valentine gift http://www.123giftboxes.info/book/1035.html giardino casa sedia giardino casa sedia http://www.ita-flower.info/7/giardino-casa-sedia.asp cerebral jersey lawyer new palsy cerebral jersey lawyer new palsy http://www.law-lawyer-en.info/tag/cerebral-jersey-lawyer-new-palsy.asp chicago lawyer rezulin chicago lawyer rezulin http://www.1-law-process.info/info/1002.php
72.36.211.* 于 2007-07-27 19:53:07发表:
Good design!
nextel ringtone program | mp3 ringtones free | free ringtones motorola | tracfone free ringtones | suonerie telefonini | mp3 to ringtone | free nextel downloads | free star wars ringtones | cheap ringtones | ringtones for sprint phones
72.36.211.* 于 2007-07-27 19:52:10发表:
Nice site!
music ringtones | us cellular free ringtones | mosquito ringtone | ingyen mp3 | free harry potter ringtones | toques polifonicos | verizon ringtones | free polyphonic ringtones | free mp3 ringtones download | ringtones midi
72.36.211.* 于 2007-07-27 19:51:51发表:
Nice site!
suonerie polifoniche samsung | klingelton kostenlos | free tmobile ringtones | mosquito ring tone | ringtones 24 | toques gratis | cellular south ringtones | ringtones for motorola q | ringtones free | eminem ringtones
72.36.211.* 于 2007-07-27 19:51:37发表:
Thank you!
verizon free ringtones | free ctu ringtone | free ringtones for nokia | bedava cep melodi | ringtones lg | free country music ringtones | dzwonki true tone | free mp3 ringtones | sonneries telephone | ringtone 24 ctu
81.20.212.* 于 2007-07-27 18:52:44发表:
box comment layout myspace box comment layout myspace http://www.123babygift.info/info/box-comment-layout-myspace.html numerisation document scientifique numerisation document scientifique http://www.law-witness-fr.info/articles/numerisation-document-scientifique sample reverse mortgage document sample reverse mortgage document http://www.1es-ley.info/sample-reverse-mortgage-document simulation loi de robien simulation loi de robien http://www.loi-avocat.info/posts/1941.asp personalized baby gifts personalized baby gifts http://www.cesta-de-regalo.info/9/personalized-baby-gifts.html power of attorney new jersey what is power of attorney new jersey what is http://www.german-law-judgement.info/7/power-of-attorney-new-jersey-what-is.asp regalo perro fuerteventura regalo perro fuerteventura http://www.regalos-navidad.info/news/regalo-perro-fuerteventura.php matrimonio documento chiesa matrimonio documento chiesa http://www.legge-corte-ita.info/matrimonio-documento-chiesa.html ley accidente de trabajo ley accidente de trabajo http://www.law-attorney-es.info/1178.html louisiana law firm louisiana law firm http://www.fr-law1.info/tag/1250.php
84.4.34.* 于 2007-07-27 18:40:25发表:
rose nursery rose nursery http://www.1-origami-blume.info/pdf/1802 creative graduation gift idea creative graduation gift idea http://www.1gift-de.info/6/1451.asp wholesale promotional gift wholesale promotional gift http://www.giftshop1.info/post/1975 idea regalo san valentino 2005 idea regalo san valentino 2005 http://www.gift-baskets-it.info/articles/1059.php pianta verde interno pianta verde interno http://www.send-flowers-it.info/7/pianta-verde-interno.php family law attorney family law attorney http://www.ita-law-attorney.info/news/family-law-attorney.php decor fleurs papier decor fleurs papier http://www.1wedding-flowers-fr.info/4/1742.html ameriquest lending mortgage predatory ameriquest lending mortgage predatory http://www.1autoloan.info/pdf/ameriquest-lending-mortgage-predatory attorney diego injury personal san attorney diego injury personal san http://www.1law-attorney-de.info/info/attorney-diego-injury-personal-san.html case civil court right supreme case civil court right supreme http://www.1familylaw.info/book/case-civil-court-right-supreme.php
74.185.38.* 于 2007-07-27 18:37:15发表:
attorney death orlando wrongful attorney death orlando wrongful http://www.law-witness.info/article/1008 personalisierte dokument personalisierte dokument http://www.1law-judgement-de.info/2/1218.html argent gratuit gagner largent cadeaux gratuit argent gratuit gagner largent cadeaux gratuit http://www.cadeau-anniversaire-fr.info/9/argent-gratuit-gagner-largent-cadeaux-gratuit.asp alabama celebrex attorney alabama celebrex attorney http://www.gesetz-gericht-de.info/online/1841.html emette documento trasporto emette documento trasporto http://www.1law-it.info/new/1078 piante vaso piante vaso http://www.flower-ita.info/1331 gift promotional gift promotional http://www.1-geschenkkorb.info/cat/gift-promotional venta ramo flor venta ramo flor http://www.es-flowers.info/1641.php san diego business law firm san diego business law firm http://www.ita-legge.info/latest/1176.php ackee seed for sale ackee seed for sale http://www.de-silk-flowers.info/files/ackee-seed-for-sale
86.132.83.* 于 2007-07-27 18:16:06发表:
oslo bread box oslo bread box http://www.1-giftshop.info/1522.php mother day gift idea mother day gift idea http://www.gift-basket-de.info/mother-day-gift-idea.html porte document publicitaire porte document publicitaire http://www.frloi.info/10/porte-document-publicitaire.php esito esame avvocato bologna 2005 esito esame avvocato bologna 2005 http://www.law-judgement-italy.info/5/1378.html car cheapest insurance quote us car cheapest insurance quote us http://www.1-healthinsurance.info/1114.php gadgets xp gadgets xp http://www.babygeschenk.info/blog/gadgets-xp.html cucciolo regalo it cucciolo regalo it http://www.gift-basket-ita.info/1/1832.asp montbrial avocat cabinet montbrial avocat cabinet http://www.loi-avocat-1.info/5/1214.html fiore matrimonio biella fiore matrimonio biella http://www.1flower-it.info/1549.asp bridge financing mortgage bridge financing mortgage http://www.1home-equity-loan.info/1932.asp
82.66.197.* 于 2007-07-27 16:48:55发表:
buy artificial flower buy artificial flower http://www.fleurs-mariage-fr.info/2007/buy-artificial-flower.asp gift basket delivery gift basket delivery http://www.1-weihnachtsgeschenk.info/7/gift-basket-delivery spedire fiori spedire fiori http://www.vendita-fiori-it.info/spedire-fiori.php nota corte universidad sevilla 2007 nota corte universidad sevilla 2007 http://www.law-lawyer-es.info/1908.html lustige geschenke fuer geburtstag lustige geschenke fuer geburtstag http://www.de-giftgadgets.info/4/1743.php birthday gift idea birthday gift idea http://www.1ideas-para-regalo.info/pdf/birthday-gift-idea.html regalo gattino torino regalo gattino torino http://www.regalo-bambino-ita.info/2/regalo-gattino-torino aquarium in plant aquarium in plant http://www.send-flowers1.info/1/1692.asp document storage system document storage system http://www.gesetz-rechtsanwalt.info/1648 connecticut real estate law connecticut real estate law http://www.1gesetz-gericht.info/1295.asp
24.32.203.* 于 2007-07-27 11:37:39发表:
attorney san francisco ca attorney san francisco ca http://www.1law-process.info/post/attorney-san-francisco-ca.asp traveler property casualty insurance traveler property casualty insurance http://www.homeinsurance1.info/online/1651.asp coffee gift basket coffee gift basket http://www.french-gift-baskets.info/posts/1678 arizona wild flower arizona wild flower http://www.12weddingflowers.info/1785.asp document imaging software document imaging software http://www.es-ley-abogado.info/articles/1589.asp clipart blumen clipart blumen http://www.deblume.info/1105.html dokumente archivierung dokumente archivierung http://www.1law-germany.info/dokumente-archivierung.asp esame avvocato firenze 2006 esame avvocato firenze 2006 http://www.1legge-giustizia.info/esame-avvocato-firenze-2006.php chaya planta medicinal chaya planta medicinal http://www.flor-artificial.info/forum/chaya-planta-medicinal west virginia mesothelioma lawyer west virginia mesothelioma lawyer http://www.1legge-giudice-it.info/docs/west-virginia-mesothelioma-lawyer.asp
71.221.69.* 于 2007-07-27 01:46:28发表:
amp quot cheque cadeaux amp quot amp quot cheque cadeaux amp quot http://www.1-gift-fr.info/1812 carol bouquet carol bouquet http://www.ita-send-flowers.info/10/carol-bouquet.php alabama mesothelioma attorney alabama mesothelioma attorney http://www.law-judgement-fr.info/files/1532 regalo natale aziendale mantova regalo natale aziendale mantova http://www.1-regali-it.info/phorum/regalo-natale-aziendale-mantova.asp ucla law school library ucla law school library http://www.1-legge.info/news/ucla-law-school-library.php business gift idea business gift idea http://www.german-baby-gift.info/ads/business-gift-idea abogado de oficio madrid abogado de oficio madrid http://www.ley-justicia-1.info/9/1570.php ley atraccion abraham hicks ley atraccion abraham hicks http://www.es-ley-testigo.info/1669.asp day gag gift valentine day gag gift valentine http://www.1baby-gift.info/1661.html california maternity leave law california maternity leave law http://www.1law-advocat.info/tools/1340.asp
125.120.136.* 于 2007-07-26 23:37:44发表:
72.36.211.* 于 2007-07-26 19:15:44发表:
Great work!
on line casinos | play blackjack online | black jack games | poker machines | online bingo games | poker game free | new no deposit casinos | world series of poker | free slot machine games | casino games online
72.36.211.* 于 2007-07-26 19:15:02发表:
Well done!
free poker | online gambling sites | slots for fun | online holdem | play roulette | free slots | no download casino | best online casinos | slot machine games free | casino game download
72.36.211.* 于 2007-07-26 19:14:28发表:
Great work!
poker free | deposit bonus casino | multiplayer poker | slot machine games | casino free online | slim slots | cleopatra slots | poker game download | bonus poker | play free online slots
72.36.211.* 于 2007-07-26 19:14:06发表:
Thank you!
download casino games | free bingo online | slot games free | free roulette | full tilt poker | play slots for free | online poker game | poker online | free casino games | live poker
72.36.211.* 于 2007-07-26 19:13:57发表:
Great work!
poker texas holdem | free slot machine | russian roulette game | blackjack for free | strip black jack | play texas holdem free | free blackjack | free strip blackjack | free money no deposit | free money casino
203.121.79.* 于 2007-07-26 02:03:26发表:
Hi! Best free mp3 music downloads site: :
free download music = free ipod music downloads = how to download music = download music free = free music for ipod = download music video = free download music = free ipod music downloads sites = music download =
http://www.fixgrout.com/cgi/ free music ipods :: http://musicdownloads4free.angelfire.com/free-music.html free music video :: http://bridgenews.org/portal_memberdata/portraits/fmusca FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/free-music.html free download music :: http://musicdownloadsmp3.tripod.com free country music downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds mp3 downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free download music :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads :: http://www.fixgrout.com/cgi/ download music for free :: http://noticeboard.calimera.org/calimera/portal_memberdata/portraits/freemusic download music video :: http://nmstandards.org/portal_memberdata/portraits/vsemoe free music download sites ::
music downloads .. download music for free .. download music video .. free music .. free mp3 .. free music .. music downloads pc ..
72.36.211.* 于 2007-07-25 20:03:10发表:
Thank you!
sonneries mobile | motorola free ringtones | free ringtones sprint | sprint phones | hudba zdarma | gratis mobilspel | online ringtone converter | caller ringtones | bedava melodi | tonos samsung
72.36.211.* 于 2007-07-25 20:02:34发表:
Good design!
free nascar ringtones | star wars ringtones | ringtones nokia | composer ringtones | free cingular real ring tone | free harry potter ringtones | sonneries gratuites | 24 klingelton | ringtones for nokia | sonnerie mp3