初学者如何学习分析函数-红联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

203.223.159.* 于 2007-08-22 09:54:44发表:

Hi boys! :
free mp3 downloads = free music download = music downloads = music downloads = music downloads = music downloads = free music downloads = free mp3 downloads = free music download =
http://www.freewebs.com/1fmusic/limewire.html free music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html free music downloads :: http://musicdownloadsmp3.tripod.com/ free mp3 downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html Free Music Downloads :: http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music download :: http://www.fixgrout.com/cgi/ free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html free music download :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage4.html free music :: http://www.fixgrout.com/cgi/musicpage35.html Free Music Downloads ::
free music .. free music downloads .. free music .. music .. legal music downloads .. free music downloads .. Free Music Downloads ..

72.36.211.* 于 2007-08-21 13:23:38发表:

72.36.211.* 于 2007-08-21 13:23:03发表:

72.36.211.* 于 2007-08-21 13:22:00发表:

72.36.211.* 于 2007-08-21 13:21:37发表:

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

72.36.211.* 于 2007-08-20 19:24:31发表:

72.36.211.* 于 2007-08-20 19:24:01发表:

72.36.211.* 于 2007-08-20 19:23:09发表:

72.36.211.* 于 2007-08-20 19:22:50发表:

72.36.211.* 于 2007-08-20 19:22:40发表:

72.36.211.* 于 2007-08-19 21:51:16发表:

72.36.211.* 于 2007-08-19 21:50:35发表:

72.36.211.* 于 2007-08-19 21:49:58发表:

72.36.211.* 于 2007-08-19 21:49:41发表:

72.36.211.* 于 2007-08-19 21:49:31发表:

72.36.211.* 于 2007-08-18 20:22:31发表:

72.36.211.* 于 2007-08-18 20:21:40发表:

72.36.211.* 于 2007-08-18 20:21:14发表:

72.36.211.* 于 2007-08-18 20:21:02发表:

72.36.211.* 于 2007-08-18 20:20:51发表:

203.223.159.* 于 2007-08-18 15:27:16发表:

Thanks boys :
free mp3 = music downloads = free music download sites = free music downloading = download music video = free limewire = limewire = free music downloading = music downloads pc =
http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free music for ipod :: http://mywebpage.netscape.com/music5site/download-music.htm free music download :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds Free Music Downloads :: http://musicdownloads4free.angelfire.com/free-music.html music downloads :: http://www.fixgrout.com/cgi/musicpage35.html free legal music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music video :: http://mywebpage.netscape.com/music5site/download-music.htm free legal music downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free music ipods ::
free mp3 .. free music ipods .. free download music .. free music ipods .. music downloads pc .. free download music .. free download music ..

203.121.67.* 于 2007-08-18 11:47:40发表:

Hi boys! :
free mp3 = free ipod music downloads = free country music downloads = download music for free = music downloads = free music downloads = free music downloads = free music ipods = music downloads pc =
http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free music :: http://mywebpage.netscape.com/music5site/download-music.htm how to download music :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds limewire :: http://musicdownloads4free.angelfire.com/free-music.html download free music :: http://www.fixgrout.com/cgi/musicpage35.html free limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm music downloads pc :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html Free Music Downloads ::
free mp3 .. music downloads pc .. free music ipods .. limewire .. mp3 downloads .. music downloads pc .. music download ..

72.36.211.* 于 2007-08-17 20:27:06发表:

72.36.211.* 于 2007-08-17 20:26:35发表:

72.36.211.* 于 2007-08-17 20:25:44发表:

72.36.211.* 于 2007-08-17 20:25:27发表:

72.36.211.* 于 2007-08-17 20:25:16发表:

203.121.67.* 于 2007-08-17 13:29:15发表:

Hi boys! :
free mp3 = free music for ipod = limewire = free music video = classical music downloads = legal music downloads = download music for free = music download free = music downloads pc =
http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html classical music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm Free Music Downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music to download :: http://musicdownloads4free.angelfire.com/free-music.html free music :: http://www.fixgrout.com/cgi/musicpage35.html music download :: http://www.fixgrout.com/cgi/musicpage31.html free music to download :: http://mywebpage.netscape.com/music5site/download-music.htm free country music downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html FREE MUSIC DOWNLOADS :: http://mywebpage.netscape.com/free5mp3/mp3music.html free download music ::
free mp3 .. free music download sites .. music download .. Free Music Downloads .. free limewire .. free mp3 music downloads .. music download free ..

72.36.211.* 于 2007-08-16 20:23:57发表:

72.36.211.* 于 2007-08-16 20:23:33发表:

72.36.211.* 于 2007-08-16 20:22:34发表:

72.36.211.* 于 2007-08-16 20:22:11发表:

72.36.211.* 于 2007-08-16 20:21:58发表:

203.121.67.* 于 2007-08-16 15:47:17发表:

Great boys :
free mp3 = music = free ipod music downloads = free music download = free music download sites = free music download = free ipod music downloads sites = limewire = music downloads pc =
http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html mp3 downloads :: http://mywebpage.netscape.com/music5site/download-music.htm free ipod music downloads sites :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music :: http://musicdownloads4free.angelfire.com/free-music.html music :: http://www.fixgrout.com/cgi/musicpage35.html music download :: http://www.fixgrout.com/cgi/musicpage31.html free country music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html how to download music ::
free mp3 .. classical music downloads .. free ipod music downloads sites .. free music for ipod .. music download free .. free music .. free music download sites ..

203.121.67.* 于 2007-08-16 14:49:59发表:

Yhanks you :
free mp3 = music download free = legal music downloads = music download = free mp3 downloads = free music to download = free music video = music download free = music downloads pc =
http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm limewire :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music to download :: http://musicdownloads4free.angelfire.com/free-music.html free music download sites :: http://www.fixgrout.com/cgi/musicpage35.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm free music :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html music download free ::
free mp3 .. how to download music .. free music downloading .. music download free .. mp3 downloads .. free ipod music downloads .. music download ..

72.36.211.* 于 2007-08-15 20:49:04发表:

72.36.211.* 于 2007-08-15 20:48:34发表:

72.36.211.* 于 2007-08-15 20:47:42发表:

72.36.211.* 于 2007-08-15 20:47:21发表:

初学者如何学习分析函数

共有 2615 条评论

频道文章

最新教程

随机推荐