初学者如何学习分析函数-红联Linux系统门户

经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。

常用的分析函数如下所列:

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

81.95.154.* 于 2007-09-01 23:05:20发表:

Great boys :
free mp3 downloads = free music download = Free Music Downloads = free mp3 downloads = limewire = limewire = FREE MUSIC DOWNLOADS = music download = free music downloads =
http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html mp3 music downloads :: 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 music downloads pc :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 :: 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 mp3 music downloads ::
free mp3 music downloads .. free music downloads .. free music .. music .. limewire .. free limewire .. music downloads pc ..

72.36.211.* 于 2007-09-01 11:46:55发表:

72.36.211.* 于 2007-09-01 11:46:13发表:

72.36.211.* 于 2007-09-01 11:45:24发表:

72.36.211.* 于 2007-09-01 11:45:04发表:

72.36.211.* 于 2007-09-01 11:44:57发表:

203.121.71.* 于 2007-09-01 01:07:01发表:

Hi boys! :
free mp3 music downloads = legal music downloads = free music download = free music downloads = limewire = LIMEWIRE = free music downloads = free music download = free mp3 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 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 music ::
music .. free mp3 music downloads .. free music downloads .. Free Music Downloads .. limewire .. limewire .. FREE MUSIC DOWNLOADS ..

81.95.154.* 于 2007-09-01 01:00:47发表:

Hi boys! :
music = free music downloads = FREE MUSIC DOWNLOADS = Free Music Downloads = limewire = LIMEWIRE = FREE MUSIC DOWNLOADS = free music downloads = music downloads =
http://musicdownloads4free.angelfire.com/free-music.html mp3 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/ 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 mp3 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 .. music .. free mp3 .. limewire .. LIMEWIRE .. free music downloads ..

203.121.67.* 于 2007-09-01 00:29:06发表:

Hi boys! :
free music downloads = free mp3 downloads = LIMEWIRE = FREE MUSIC DOWNLOADS = free limewire = LIMEWIRE = music = free music = free limewire =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html FREE MUSIC DOWNLOADS :: http://www.geocities.com/musicdowmoads4f/limewire.htm limewire :: http://musicdownloadsmp3.tripod.com/ free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://musicdownloadsmp3.tripod.com/ limewire :: http://musicdownloads4free.angelfire.com/free-music.html free music download :: http://musicdownloadsmp3.tripod.com/ music downloads :: http://www.freewebs.com/1fmusic/limewire.html LIMEWIRE :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html music downloads ::
music .. Free Music Downloads .. LIMEWIRE .. Free Music Downloads .. limewire .. free limewire .. music downloads ..

72.36.211.* 于 2007-08-31 11:29:44发表:

Good design!
nouveau casino | jouer casino virtuel blackjack | machine mise sous pli | jouer casino en ligne | machine e0 sous

72.36.211.* 于 2007-08-31 11:29:14发表:

72.36.211.* 于 2007-08-31 11:28:11发表:

72.36.211.* 于 2007-08-31 11:27:48发表:

72.36.211.* 于 2007-08-31 11:27:34发表:

203.121.71.* 于 2007-08-31 02:20:04发表:

Great boys :
MUSIC DOWNLOADS = free music downloads = FREE MUSIC DOWNLOADS = music = limewire = limewire = FREE MUSIC DOWNLOADS = music downloads = music downloads =
http://musicdownloads4free.angelfire.com/free-music.html music downloads :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html free mp3 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 music downloads pc :: http://www.fixgrout.com/cgi/musicpage31.html legal music downloads :: http://www.freewebs.com/1fmusic/limewire.html free mp3 :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads ::
legal music downloads .. Free Music Downloads .. music .. MUSIC DOWNLOADS .. limewire .. LIMEWIRE .. free music ..

81.95.154.* 于 2007-08-31 01:45:42发表:

Hi boys! :
free music downloads = free music downloads = legal music downloads = music downloads = limewire = free limewire = music downloads = FREE MUSIC DOWNLOADS = music downloads =
http://musicdownloads4free.angelfire.com/free-music.html free music :: http://www.fixgrout.com/cgi/musicpage31.html free music :: 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 music downloads :: http://www.freewebs.com/1fmusic/limewire.html music download :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html free limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads ::
mp3 music downloads .. free mp3 downloads .. Free Music Downloads .. FREE MUSIC DOWNLOADS .. limewire .. limewire .. music downloads ..

203.121.67.* 于 2007-08-31 01:10:01发表:

Hi boys! :
music = music downloads = LIMEWIRE = free music downloads = limewire = LIMEWIRE = FREE MUSIC DOWNLOADS = free mp3 downloads = LIMEWIRE =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free mp3 music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html mp3 music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://musicdownloadsmp3.tripod.com/ free music downloads :: 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/ free music downloads :: http://www.freewebs.com/1fmusic/limewire.html LIMEWIRE :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm free music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html free music ::
music .. MUSIC DOWNLOADS .. free limewire .. free music downloads .. LIMEWIRE .. free limewire .. free music downloads ..

72.36.211.* 于 2007-08-30 12:00:18发表:

72.36.211.* 于 2007-08-30 11:59:46发表:

72.36.211.* 于 2007-08-30 11:58:48发表:

72.36.211.* 于 2007-08-30 11:58:18发表:

72.36.211.* 于 2007-08-30 11:58:07发表:

72.36.211.* 于 2007-08-29 12:02:01发表:

72.36.211.* 于 2007-08-29 12:01:25发表:

72.36.211.* 于 2007-08-29 12:00:29发表:

72.36.211.* 于 2007-08-29 12:00:02发表:

72.36.211.* 于 2007-08-29 11:59:53发表:

81.95.154.* 于 2007-08-28 12:46:02发表:

Thanks boys :
free music = music = free music = legal music downloads = limewire = free limewire = free music downloads = Free Music Downloads = free music =
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/ free 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 music downloads pc :: http://www.fixgrout.com/cgi/musicpage31.html free music downloads :: http://www.freewebs.com/1fmusic/limewire.html music :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads ::
free music .. free music downloads .. free music downloads .. free music download .. limewire .. limewire .. FREE MUSIC DOWNLOADS ..

203.121.71.* 于 2007-08-28 12:22:28发表:

Yhanks you :
free music downloads = music = Free Music Downloads = free mp3 music downloads = limewire = LIMEWIRE = FREE MUSIC DOWNLOADS = FREE MUSIC DOWNLOADS = free music =
http://musicdownloads4free.angelfire.com/free-music.html free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html music downloads :: http://www.fixgrout.com/cgi/ free mp3 :: 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 free mp3 downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html music downloads ::
music downloads .. free music .. free music download .. free mp3 .. limewire .. limewire .. free music downloads ..

203.121.67.* 于 2007-08-28 11:54:06发表:

Great boys :
Free Music Downloads = MUSIC DOWNLOADS = free limewire = free mp3 downloads = free limewire = free limewire = free music downloads = free music downloads = free limewire =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 legal music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music :: http://www.geocities.com/musicdowmoads4f/limewire.htm limewire :: http://musicdownloadsmp3.tripod.com/ free music :: 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/ MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html limewire :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm free music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html music ::
FREE MUSIC DOWNLOADS .. mp3 music downloads .. LIMEWIRE .. mp3 music downloads .. LIMEWIRE .. free limewire .. free music ..

72.36.211.* 于 2007-08-28 11:44:49发表:

Well done!
jeu casino online | roulette virtuelle | machine a sous | jouer casino france blackjack | black jack en ligne

72.36.211.* 于 2007-08-28 11:44:13发表:

72.36.211.* 于 2007-08-28 11:43:10发表:

72.36.211.* 于 2007-08-28 11:42:59发表:

72.36.211.* 于 2007-08-28 11:42:34发表:

72.36.211.* 于 2007-08-27 13:49:02发表:

72.36.211.* 于 2007-08-27 13:48:32发表:

72.36.211.* 于 2007-08-27 13:47:26发表:

72.36.211.* 于 2007-08-27 13:47:03发表:

72.36.211.* 于 2007-08-27 13:46:52发表:

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐