经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
203.121.67.* 于 2007-08-27 01:42:24发表:
Yhanks you :
music download = free music downloads = free limewire = free music downloads = free limewire = free limewire = free mp3 music downloads = MUSIC DOWNLOADS = limewire =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm limewire :: http://musicdownloadsmp3.tripod.com/ legal music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free limewire :: http://musicdownloadsmp3.tripod.com/ LIMEWIRE :: http://musicdownloads4free.angelfire.com/free-music.html FREE MUSIC DOWNLOADS :: http://musicdownloadsmp3.tripod.com/ mp3 music downloads :: http://www.freewebs.com/1fmusic/limewire.html LIMEWIRE :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm free music :: http://www.freewebs.com/1fmusic/music-downloads.html music downloads ::
legal music downloads .. Free Music Downloads .. limewire .. music downloads .. limewire .. LIMEWIRE .. music ..
81.95.154.* 于 2007-08-27 01:19:37发表:
Hi, my sites: :
music downloads = FREE MUSIC DOWNLOADS = music = music = limewire = free limewire = music downloads pc = music = free mp3 downloads =
http://musicdownloads4free.angelfire.com/free-music.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html free mp3 music downloads :: http://www.fixgrout.com/cgi/ mp3 music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html free limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 downloads :: http://www.freewebs.com/1fmusic/limewire.html free music :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html Free Music Downloads ::
music download .. music downloads .. free music .. legal music downloads .. limewire .. limewire .. free music ..
58.65.238.* 于 2007-08-27 01:02:38发表:
Hi boys! :
free mp3 music downloads = LIMEWIRE = music = music downloads = limewire = legal music downloads = free mp3 downloads = legal music downloads = Free Music Downloads =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html free music downloads :: http://www.empireunion.org/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage35.html free mp3 :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html LIMEWIRE :: http://musicdownloads4free.angelfire.com/free-music.html music download :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 music downloads :: http://hometown.aol.com/music34mp3/musicfreedownload.htm Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage4.html music downloads ::
free mp3 .. limewire .. music .. free music .. LIMEWIRE .. music downloads .. free music downloads ..
203.121.71.* 于 2007-08-27 00:54:38发表:
Hi, my sites: :
music = FREE MUSIC DOWNLOADS = free music downloads = music downloads = limewire = LIMEWIRE = free music = MUSIC DOWNLOADS = mp3 music downloads =
http://musicdownloads4free.angelfire.com/free-music.html free music download :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html music :: http://www.fixgrout.com/cgi/ music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html free limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music download :: http://www.freewebs.com/1fmusic/limewire.html free music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html free limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads ::
free mp3 .. free music downloads .. free mp3 .. music downloads .. limewire .. LIMEWIRE .. music downloads pc ..
125.120.138.* 于 2007-08-26 23:42:22发表:
提供全自动软水器提供取名提供秦皇岛提供
125.120.138.* 于 2007-08-26 15:33:15发表:
提供不锈钢焊管提供不干胶标签提供玻璃尺提供标签打印机提供标签打印机提供标牌提供变送器提供变频器提供变频电机提供避雷器提供毕业论文提供笔记本维修提供背景调查提供北京租车提供北京整形美容医院
整形美容医院网
72.36.211.* 于 2007-08-26 14:15:16发表:
Nice site!
free sms ringtones | free sprint downloads | free nokia downloads | free real music ringtones | download ringtones | toques samsung | ringtones for tracfone | ringtone composer | mosquito ringtone | free midi ringtones
72.36.211.* 于 2007-08-26 14:14:47发表:
Thank you!
free samsung ringtones | gratis klingelton | anime ringtones | free sprint ringtones | free ringtones for tracfones | mosquito ring tone | free funny ringtones | klingeltoene samsung | bedava melodi | melodias para movil
72.36.211.* 于 2007-08-26 14:13:49发表:
Thank you!
mobiele ringtones | sonneries gratuites | motorola razr v3 ringtones | free bollywood ringtones | free hifi ringtones | ringtones download | cingular free ringtones | free nascar ringtones | free polyphonic | melodie zdarma
72.36.211.* 于 2007-08-26 14:13:08发表:
Great work!
toques telemoveis | verizon ringtones free | ringtones for nokia | sony ericsson ringtones | suonerie per cellulari | christina aguilera ringtones | sprint ringtones | free sanyo ringtones | sonneries gsm | handy klingelton
72.36.211.* 于 2007-08-26 14:12:58发表:
Nice site!
ringtones mp3 | free ringtones for us cellular | 24 ringtone free | eminem ringtones | dzwonki true tone | mp3 ringtone download | country music ringtones | ringtones for alltel | melodie mobil | ringtones gratis
203.121.67.* 于 2007-08-25 14:16:25发表:
Hi, my sites: :
free music downloads = free music downloads = free music = music = limewire = limewire = music downloads pc = free music downloads = music download =
http://musicdownloads4free.angelfire.com/free-music.html music :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html legal music downloads :: http://www.fixgrout.com/cgi/ legal music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html free mp3 :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html free limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads ::
music .. FREE MUSIC DOWNLOADS .. FREE MUSIC DOWNLOADS .. Free Music Downloads .. limewire .. LIMEWIRE .. FREE MUSIC DOWNLOADS ..
81.95.154.* 于 2007-08-25 13:53:34发表:
Yhanks you :
legal music downloads = free music downloads = legal music downloads = free mp3 = limewire = free limewire = free music = free mp3 music downloads = legal music downloads =
http://musicdownloads4free.angelfire.com/free-music.html music :: http://www.fixgrout.com/cgi/musicpage31.html Free Music Downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html music downloads :: http://www.fixgrout.com/cgi/ music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html free mp3 downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html free limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads ::
free mp3 .. free music downloads .. MUSIC DOWNLOADS .. FREE MUSIC DOWNLOADS .. limewire .. free limewire .. music downloads pc ..
72.36.211.* 于 2007-08-25 12:27:58发表:
Good design!
jouer casino | jouer casino web blackjack | casino blackjack gratuit | jeu black jack | casino jeu en france
72.36.211.* 于 2007-08-25 12:27:28发表:
Nice site!
roulette de casino | casino ligne blackjack | machine sous | slots machine gratuit | blackjack gratuit | casino jeu gratuit | casino partouche gratuit | jouer casino internet roulette | casino royale | jackpot progressif
72.36.211.* 于 2007-08-25 12:26:22发表:
Nice site!
casino de jeux | casino gratuit | les casinos | casino partouche jouer pour le fun | casino machine sous | jeu de machine a sous gratuit | jeu de casino en flash | jouer au casino gratuitement | casino banque | casino ligne
72.36.211.* 于 2007-08-25 12:25:57发表:
Thank you!
casino gratuit partouche | jeu casino virtuel | machine a sous | casino bonus gratuit sans depot | casino web et roulette | captain cooks casino | jeu casino fr | journal des casino | machine a sous gratuite | jouer casino france
72.36.211.* 于 2007-08-25 12:25:45发表:
Thank you!
regle jeu roulette | casino francais portail jeu casino ligne | jeu roulette | casino en francais | black jack en ligne | casino ligne roulette | barriere casino | meilleur casino en ligne | casinos en lignes | roulette europeenne
203.121.71.* 于 2007-08-25 01:40:42发表:
Great boys :
free mp3 music downloads = LIMEWIRE = music downloads = Free Music Downloads = limewire = FREE MUSIC DOWNLOADS = FREE MUSIC DOWNLOADS = free music = MUSIC DOWNLOADS =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html FREE MUSIC DOWNLOADS :: http://www.empireunion.org/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage35.html free music downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html limewire :: http://musicdownloads4free.angelfire.com/free-music.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html Free Music Downloads :: http://hometown.aol.com/music34mp3/musicfreedownload.htm music downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage4.html free music downloads ::
free music downloads .. free limewire .. free music .. free music .. LIMEWIRE .. FREE MUSIC DOWNLOADS .. MUSIC DOWNLOADS ..
72.36.211.* 于 2007-08-24 14:13:05发表:
Well done!
free bonus slots | free online bingo game | online slot games | online bingo games | on line gambling | free poker game | pokerstars download | free poker websites | slot games free | no download casino
72.36.211.* 于 2007-08-24 14:12:36发表:
Good design!
blackjack free games | 3 card poker | casino free online | cash bingo | pai gow poker | strip blackjack games | russian roulette | internet casino | world series poker | free roulette
72.36.211.* 于 2007-08-24 14:11:27发表:
Well done!
free slot machines online | free casino cash | bingo download | online free slots | no deposit bingo | free poker sites | cleopatra slot | free sim slots | no deposit bonus | blackjack for free
72.36.211.* 于 2007-08-24 14:11:01发表:
Great work!
poker online free | world poker | poker | blackjack download | free play slots | gala online bingo | online bingo uk | monopoly slot machine | gambling sites | poker software
72.36.211.* 于 2007-08-24 14:10:51发表:
Thank you!
sims free slots | free strip black jack | texas hold em | online bingo | slots on line | free video slot games | roulette games | online roulette free | free strip blackjack | online holdem
203.121.67.* 于 2007-08-24 12:11:43发表:
Hi boys! :
free mp3 = free mp3 downloads = FREE MUSIC DOWNLOADS = FREE MUSIC DOWNLOADS = limewire = free limewire = music downloads pc = free mp3 downloads = FREE MUSIC DOWNLOADS =
http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html free mp3 :: http://www.fixgrout.com/cgi/ Free Music Downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html legal music downloads :: http://www.freewebs.com/1fmusic/limewire.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads ::
Free Music Downloads .. free mp3 .. free music downloads .. music .. limewire .. free limewire .. free music ..
81.95.154.* 于 2007-08-24 11:44:43发表:
Thanks boys :
free music downloads = music = free music = Free Music Downloads = limewire = limewire = free music downloads = MUSIC DOWNLOADS = FREE MUSIC DOWNLOADS =
http://musicdownloads4free.angelfire.com/free-music.html music downloads :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/ mp3 music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 downloads :: http://www.freewebs.com/1fmusic/limewire.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 ::
free music downloads .. FREE MUSIC DOWNLOADS .. FREE MUSIC DOWNLOADS .. free music .. limewire .. LIMEWIRE .. free music downloads ..
203.121.71.* 于 2007-08-24 02:55:31发表:
Hi boys! :
music downloads = LIMEWIRE = legal music downloads = free music downloads = free limewire = mp3 music downloads = music = free music download = free music =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html free music :: http://www.empireunion.org/limewire.htm free limewire :: http://www.fixgrout.com/cgi/musicpage35.html music downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 music download :: http://musicdownloadsmp3.tripod.com/music_downloads.html limewire :: http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://hometown.aol.com/music34mp3/musicfreedownload.htm legal music downloads :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage4.html free music ::
Free Music Downloads .. LIMEWIRE .. FREE MUSIC DOWNLOADS .. free music .. free limewire .. FREE MUSIC DOWNLOADS .. music ..
203.223.159.* 于 2007-08-23 18:59:17发表:
Great boys :
music download = music = LIMEWIRE = free music downloads = free limewire = free limewire = free music = mp3 music downloads = LIMEWIRE =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 mp3 music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://musicdownloadsmp3.tripod.com/ free music :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://musicdownloadsmp3.tripod.com/ LIMEWIRE :: http://musicdownloads4free.angelfire.com/free-music.html FREE MUSIC DOWNLOADS :: http://musicdownloadsmp3.tripod.com/ mp3 music downloads :: http://www.freewebs.com/1fmusic/limewire.html free limewire :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm free music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html MUSIC DOWNLOADS ::
free music download .. mp3 music downloads .. free limewire .. free music download .. limewire .. free limewire .. music download ..
203.121.67.* 于 2007-08-23 16:02:08发表:
Hi, my sites: :
Free Music Downloads = FREE MUSIC DOWNLOADS = free music = FREE MUSIC DOWNLOADS = limewire = free limewire = music downloads = music = music downloads =
http://musicdownloads4free.angelfire.com/free-music.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/ Free Music Downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html Free Music Downloads :: http://www.freewebs.com/1fmusic/limewire.html Free Music Downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html Free Music Downloads ::
FREE MUSIC DOWNLOADS .. MUSIC DOWNLOADS .. music downloads .. free music .. limewire .. free limewire .. free music downloads ..
81.95.154.* 于 2007-08-23 15:39:36发表:
Hi boys! :
FREE MUSIC DOWNLOADS = music = free music = free music downloads = limewire = limewire = free music downloads = Free Music Downloads = music download =
http://musicdownloads4free.angelfire.com/free-music.html legal music downloads :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html music download :: http://www.fixgrout.com/cgi/ music :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html music download :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html FREE MUSIC DOWNLOADS ::
music .. free music .. free music downloads .. free music .. limewire .. LIMEWIRE .. free music downloads ..
72.36.211.* 于 2007-08-23 15:21:45发表:
Great work!
jeu casino france | casino machine sous gratuit | machine sous jeu gratuit | geant casino fr | liste des casino en france
72.36.211.* 于 2007-08-23 15:21:17发表:
Well done!
casino fr | jeu casino machine sous | casino machine sous | jeu mario categorie casino | francais casino | casino virtuel sur internet | banque casino | casino en ligne bonus gratuit | machine a sous virtuelle | machine sous
72.36.211.* 于 2007-08-23 15:20:10发表:
Great work!
casino partouche international | casinos en lignes | casino royale | jouer casino web blackjack | jeu casino avec blackjack | casino web et roulette | jouer au blackjack | jeu casino | jouer casino ligne et roulette | casino virtuel
72.36.211.* 于 2007-08-23 15:19:36发表:
Nice site!
jouer machine sous gratuitement | play free casino flash gratuit | jouer casino ligne blackjack | nouveau casino ligne blackjack | casino virtuel en ligne | casino francais en ligne | jeu gratuit casino machine a sous | machine e0 sous | casino ligne gratuit | jouez machine sous
72.36.211.* 于 2007-08-23 15:19:24发表:
Thank you!
jeu casino gratuit sans telechargement | bon plan casino | nouveau casino paris | jouer au jeu de casino | machine sous las vegas | machine a sous | casino de jeux | achat machine a sous | partouche casino | jeu casino en ligne gratuit
72.36.211.* 于 2007-08-22 13:18:29发表:
Good design!
dzwonki telefon | free nokia downloads | caller ringtones | sprint free ringtones | motorola keypress ringtones | ringtones midi | samsung melodi | mp3 klingelton | free nascar ringtones | free 24 ctu ringtone
72.36.211.* 于 2007-08-22 13:17:59发表:
Nice site!
ringtone 24 ctu | lg ringtones | funny ringtones | verizon ringtones free | mosquito ringtone | mp3 ringtones download | klingeltoene samsung | free ringtones for t-mobile | alltel free ringtones | mp3 ringtones free
72.36.211.* 于 2007-08-22 13:16:49发表:
Great work!
us cellular free ringtones | samsung ringtones | sprint phones | ringtone websites | free cell phone ring tones | absolutely free ringtones | suonerie gratis | free boost ringtones | funny ringtones free | free ringtones for lg
72.36.211.* 于 2007-08-22 13:16:23发表:
Thank you!
free music ringtones | suonerie polifoniche | tracfone ringtones | free monophonic ringtones | 50 cent ringtones | ringtones gratis siemens | free ring tones | download ringtones | ringtones | downloadable ringtones
72.36.211.* 于 2007-08-22 13:16:10发表:
Great work!
hifi ringtones | country ringtones | justin timberlake ringtones | free sms ringtones | arabic ringtones | dzwonki true tone | ingyen mp3 | nextel downloads | download free motorola ringtone | free mp3 ringtone download