经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-04-22 12:32:09发表:
Well done!
free online poker | world poker | online blackjack | games on line | strip blackjack free | monopoly slot machine | caribbean poker | texas hold em | slots free | download casino games
72.36.211.* 于 2007-04-22 12:31:50发表:
Great work!
online roulette game | free slot game | online casino | free fun slots | new no deposit online casinos | download poker games | free bingo online | free poker game | play casino games | free casino downloads
72.36.211.* 于 2007-04-22 12:31:23发表:
Great work!
empire poker | free online strip blackjack | roulette | no deposit online casinos | free monopoly slots | video slot | free blackjack game | play slot machines | free poker | slot machine game
72.36.211.* 于 2007-04-21 11:07:52发表:
Thank you!
free texas holdem | free slots for fun | video slots | free casino games online | free roulette | play slot machines for free | download poker game | on line casinos
72.36.211.* 于 2007-04-21 11:07:22发表:
Well done!
online slot machines | play black jack | poker sites | online casino games | free online games | free poker websites | slot machine software | play free blackjack | internet casinos | no download casino
72.36.211.* 于 2007-04-21 11:06:56发表:
Thank you!
poker games download | free slot machine downloads | bingo games | free blackjack games | free multi line slots | free slot machines games | free slot machine play | play bingo online | caribbean stud poker | party poker
72.36.211.* 于 2007-04-21 11:06:33发表:
Good design!
best poker sites | texas holdem | internet casino games | casino game download | free casino money | texas holdem poker | download free poker | no deposit casino bonus | free on line poker | free sim slots
72.36.211.* 于 2007-04-21 11:06:04发表:
Nice site!
russian roulette games | black jack online | free slot games online | free slots | online games | play blackjack | texas poker | free money no deposit casinos | internet bingo | free online poker games
72.36.211.* 于 2007-04-20 10:51:29发表:
Nice site!
verizon free ringtones | motorola ringtone | free hi fi ringtones | free mp3 ringtone download | real ringtones | sms ringtones | ringtones samsung | mp3 to ringtone | free cingular ringtones | centennial ringtones
72.36.211.* 于 2007-04-20 10:50:50发表:
Great work!
free ringtones for tracfone | crazy frog ring tone | free polyphonic ringtones | tmobile free ringtones | funny ringtones | download free ringtone | verizon ctu ringtone | free boost ringtones | free ringtones for sprint | 50 cent ringtones
72.36.211.* 于 2007-04-20 10:50:21发表:
Good design!
midi ringtone | keypress ringtones | free polyphonic ringtone | cellular one ringtones | midi ringtones | nokia ringtones | free kyocera ringtones | simpsons ringtone | motorola q ringtones | ctu ringtone verizon
72.36.211.* 于 2007-04-20 10:50:05发表:
Good design!
free nextel downloads | wav ringtones | cricket ringtones | harry potter ringtones | cell phone ringtones | free nokia ringtone | anime ringtones | free ringtones for t-mobile | free bollywood ringtones | free country ringtones
72.36.211.* 于 2007-04-20 10:49:33发表:
Well done!
free ringtones for lg | free ringtones alltel | free motorola downloads | free ctu ringtone | free lg ringtones | blackberry ringtones | mp3 to ringtone converter | free nextel ringtones | ringtone uploader | free ringtone downloads
72.36.211.* 于 2007-04-19 11:57:28发表:
Nice site!
casinos on line | casino open usa | online free slots | play bingo online | poker games online | best online casinos | casino online download | free three card poker | free slot | free on line slots
72.36.211.* 于 2007-04-19 11:57:03发表:
Thank you!
poker stars | bingo online | slot machine games free | black jack download | free slots no downloads | free no deposit casinos | free slot machines games | download poker | best poker sites | free video poker
72.36.211.* 于 2007-04-19 11:56:34发表:
Nice site!
free online casino | poker star | cleopatra slots | poker web sites | casino on line | strip black jack | holdem poker | gambling machines | online slots | free video
72.36.211.* 于 2007-04-19 11:56:18发表:
Good design!
free roulette | free cleopatra slots | no deposit bonus | play roulette | video slot | free slot downloads | game slot | play poker online | sim slots | casino on net
72.36.211.* 于 2007-04-19 11:55:49发表:
Well done!
roulette download | on line gambling | strip blackjack games | free online bingo games | black jack games | casino free | omaha poker | online casino games | slot games free | black jack free
72.36.211.* 于 2007-04-19 02:10:35发表:
Nice site!
ringtones 24 | ringtones for nextel | us cellular free ringtones | midi ringtone | free ringtones for cricket | motorola razr v3 ringtones | gospel ringtones | 24 ring tones | free mp3 download | ringtone midi
72.36.211.* 于 2007-04-19 02:10:05发表:
Well done!
keypress ringtones | ringtone 24 ctu | free phone downloads | free ringtones motorola | mosquito ringtone | free cellular ringtones | hindi ringtone | centennial ringtones | download ringtones free | sms ringtones
72.36.211.* 于 2007-04-19 02:09:33发表:
Good design!
crazy frog ring tone | free anime | harry potter ringtone | sprint free ringtones | ringtone jukebox | nokia free download | free christian ringtones | free ringtones cingular | free hifi ringtones | free samsung ringtones
72.36.211.* 于 2007-04-19 02:09:06发表:
Well done!
free boost ringtones | free mp3 tones | nokia free downloads | ringtones cingular | free real ringtones for cingular | free tmobile ringtones | free polyphonic ringtones | free wav ringtones | ringtones mp3 free | cingular free ringtones
72.36.211.* 于 2007-04-19 02:08:32发表:
Nice site!
ringtones composer | 24 ctu ringtones | free ringtone converter | nokia ringtones | free sprint downloads | cellular south | download free motorola ringtone | free real tone ringtones | ringtone websites | polyphonic ringtones
190.51.19.* 于 2007-04-17 20:33:49发表:
http://8f1afc22c8b14e042a3663239214c524-t.ghoiou0.info 8f1afc22c8b14e042a3663239214c524 http://8f1afc22c8b14e042a3663239214c524-b1.ghoiou0.info 8f1afc22c8b14e042a3663239214c524 http://8f1afc22c8b14e042a3663239214c524-b3.ghoiou0.info 196c3da0ce3e9a23267e7eab02ad2b11
72.232.250.* 于 2007-04-17 10:11:20发表:
Good design!
poker machines | free online poker | play free slots | online poker | free slots for fun | play poker for free | free slot games | strip black jack | free online video slots | free money casinos
72.232.27.* 于 2007-04-17 10:10:54发表:
Thank you!
black jack | gambling online | free blackjack | slots for fun | slot machines | casino no deposit | slots of fun | free blackjack games | play black jack | free online texas holdem
72.232.27.* 于 2007-04-17 10:10:23发表:
Good design!
on line gambling | play blackjack | play free roulette | world series poker | new no deposit casino | bingo games | black jack download | free sims slots | play blackjack online | free texas hold em online
72.232.250.* 于 2007-04-17 10:09:17发表:
Great work!
caribbean poker | free online poker | flash casino | poker star | slot machine | no deposit bonus casinos | free joker poker | online roulette | monopoly slot machine | online poker games
72.232.250.* 于 2007-04-17 10:08:58发表:
Well done!
online casino | online poker game | play online poker | free poker | free on line slots | video slots free | play bingo online | gambling machines | free play slots | us poker sites
72.232.27.* 于 2007-04-16 11:06:54发表:
Good design!
free sprint pcs ringtones | ringtones mp3 free | ringtones for nokia | download free motorola ringtone | 24 ctu ringtone | 24 ring tones | nokia ringtones | harry potter ringtones | keypress ringtones | ctu ringtone mp3
72.232.250.* 于 2007-04-16 11:05:29发表:
Thank you!
free sms ringtones | tmobile ringtones | free alltel ringtones | free ringtone creator | mosquito ringtone | ctu ring tone | free ringtones | ringtone ctu | free ringtones for us cellular | cingular free ringtones
72.232.27.* 于 2007-04-16 11:04:14发表:
Great work!
download free ringtones | free ringtones lg | ringtone midi | mobile ringtones | free midi ringtone | tracfone ringtones | nokia free ringtones | download free polyphonic ringtones | sanyo ringtones | free ringtones for verizon
72.232.27.* 于 2007-04-16 11:03:35发表:
Thank you!
free nextel downloads | u s cellular ringtones | ringtones motorola | free ringtones sprint | free sanyo ringtones | free anime ringtones | free polyphonic | free ringtones for sprint | free 24 ctu ringtone | free verizon ringtones
72.232.27.* 于 2007-04-16 11:03:17发表:
Well done!
country ringtones | motorola keypress ringtones | free cricket ringtones | free boost mobile ringtones | nextel ringtone | star wars ringtones | verizon ring tones | funny ringtones | free ringtones for alltel | absolutely free ringtones
72.232.250.* 于 2007-04-15 16:15:26发表:
Nice site!
best bonus casino | free black jack game | free no deposit casinos | free poker game download | texas hold em | online strip blackjack | download poker | online poker | poker web sites | online games
72.232.250.* 于 2007-04-15 16:15:04发表:
Thank you!
download blackjack | download poker games | download slots | play roulette for free | on line poker | free slot machine game | strip blackjack game | free online casino | video poker | us poker sites
72.232.250.* 于 2007-04-15 16:14:45发表:
Well done!
world series poker | casino black jack | free play slots | no deposit bonus casinos | online free blackjack | gambling online | play poker online | texas holdem online | play blackjack free | roulette game
72.232.250.* 于 2007-04-15 16:14:14发表:
Good design!
strip blackjack | free online texas hold em | no deposit online casinos | poker games online | gambling sites | casino game | free slot machine | online texas holdem | live poker | free bingo online
72.232.250.* 于 2007-04-15 16:14:00发表:
Great work!
free online slot games | online free roulette | computer poker | bingo online | free slots no downloads | multiplayer poker | slim slots free | play free blackjack online | casino game download | deposit bonus casino
72.36.211.* 于 2007-04-14 12:07:10发表:
Great work!
ringtone 24 ctu | free ringtones for boost mobile | razr ringtones | free ringtones lg | samsung free ringtones | free ringtones for cricket | ringtone mp3 | arabic ringtones | free cell phone ring tones | cingular wireless ringtones