经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.192.* 于 2007-05-01 08:10:30发表:
Nice site!
slot games free | free bingo | free casino game | free slot games no download | slots on line | free slot machines games | casino online download | casino no deposit | free video slots | new online casinos
72.36.192.* 于 2007-04-30 06:39:11发表:
Good design!
free slots no downloads | play black jack | black jack games | play slots for free | free slots game | free roulette games | free texas holdem online | caribbean poker | play money poker | poker game online
72.36.192.* 于 2007-04-30 06:38:39发表:
Well done!
bingo online | keno online | free slim slots | free casino | texas holdem free online | world series of poker | roulette online | no download slots | texas holdem poker | cleopatra slots
72.36.192.* 于 2007-04-30 06:38:19发表:
Thank you!
computer poker | free online texas holdem | free bonus slots | online texas hold em | texas poker | poker machines | free poker money | free joker poker | free money no deposit casinos | free multi line slots
72.36.192.* 于 2007-04-30 06:38:07发表:
Well done!
blackjack strip | full tilt poker | online casino games | free slot games | download casino | gambling sites | virtual poker | free poker games | slots games | play free slots
72.36.192.* 于 2007-04-30 06:37:55发表:
Great work!
blackjack download | casino free online | free online casinos | free play slot machines | new free money online casinos | internet bingo | black jack game | free online games | free online slots | free cleopatra slots
72.36.192.* 于 2007-04-29 08:19:49发表:
Nice site!
online roulette game | planet poker | free play slots | free games on line | online slot machines | free no deposit casino | three card poker | free money no deposit casinos | 3 card poker | online gambling sites
72.36.192.* 于 2007-04-29 08:19:30发表:
Nice site!
free strip blackjack | casino slots | free online casino game | free video slot games | black jack | free online slots | free multi line slots | flash casino games | slim slots | free online slot machines
72.36.192.* 于 2007-04-29 08:19:04发表:
Thank you!
new casinos | cleopatra slots | world poker | slot games | computer poker | slot machine software | online holdem | casino black jack | free poker online | texas poker
72.36.192.* 于 2007-04-29 08:17:59发表:
Well done!
free roulette | free poker games | free black jack | download casino | paradise poker | online strip blackjack | download free poker game | free money casino | best online casinos | download poker
72.36.192.* 于 2007-04-29 08:17:47发表:
Thank you!
casino free game online | free internet poker | full tilt poker | play slot machines | texas hold em poker | play texas hold em | sim slots | free slot games no download | free online bingo games | world series of poker
60.176.198.* 于 2007-04-29 05:46:37发表:
糖尿病医院设有糖尿病足、麻疼，糖尿病肾病、糖尿病眼病，糖尿病心脑血管病,
72.36.192.* 于 2007-04-28 09:10:30发表:
Great work!
free downloadable ringtones | voice ringtone | free cricket ringtones | ringtone midi | country music ringtones | u s cellular ringtones | ringtones wav | free polyphonic ringtone | free mp3 ringtones | free mobile downloads
72.36.192.* 于 2007-04-28 09:09:43发表:
Good design!
free ringtones for alltel | free lg ringtones | cellphone ringtones | ringtones for verizon | ringtone composer | free ringtone converter | ctu ringtone verizon | crazy frog ringtone | razr ringtones | us cellular ring tones
72.36.192.* 于 2007-04-28 09:09:21发表:
Well done!
nextel downloads | free suncom ringtones | music ringtones | samsung free ringtones | free ringtones for t mobile | ringtones lg | nokia free ringtones | free cell phone ringtones | free samsung ringtones | free motorola ringtones
72.36.192.* 于 2007-04-28 09:09:09发表:
Thank you!
free polyphonic ringtones | ringtone websites | christian music ringtones | motorola ringtones | free sprint pcs ringtones | free tracfone ringtones | bollywood ringtones | free ringtones alltel | nokia downloads | ringtones verizon
72.36.192.* 于 2007-04-28 09:08:58发表:
Nice site!
free tmobile ringtones | cingular wireless ringtones | sprint phones | ringtones for motorola | nokia download | us cellular ringtones | ringtone uploader | verizon ring tones | free sms ringtones | free anime ringtones
72.36.211.* 于 2007-04-27 14:35:48发表:
Thank you!
free strip blackjack | poker games download | online black jack game | download casino games | play free slot machines | black jack | free casino slot games | free online games
72.36.211.* 于 2007-04-27 14:35:26发表:
Nice site!
free casino cash | poker downloads | play money poker | multiplayer poker | play bingo online | slot machines games | slots of fun | blackjack game | no limit texas hold em | play free online slots
72.36.211.* 于 2007-04-27 14:35:09发表:
Thank you!
texas holdem free online | strip blackjack free | free online slots | casino free online | free gambling | free online roulette | no deposit online casino | online blackjack free | free slots online | texas holdem poker
72.36.211.* 于 2007-04-27 14:34:58发表:
Good design!
flash casinos | blackjack download | free online slots no downloads | free poker games | on line poker | free slot machine downloads | black jack online | free online video slots | free slots machines | free online poker game
72.36.211.* 于 2007-04-27 14:34:48发表:
Well done!
us poker sites | video poker | free online bingo games | russian roulette games | new casinos | download free poker games | casino free | free poker game | online holdem | sims slots
72.36.211.* 于 2007-04-26 18:15:25发表:
Great work!
24 ctu ringtone verizon | nokia free ringtones | harry potter ringtones | free ringtones for nextel | free ringtones for t-mobile | star wars ringtone | ctu ringtone mp3 | mtv ringtones | wwe ringtones | free cellular south ringtones
72.36.211.* 于 2007-04-26 18:15:09发表:
Well done!
christian ringtones | mp3 ringtones download | mosquito ring tone | free wwe ringtones | ringtones download | free polyphonic ringtones | free ringtones for lg | razr ringtones | ctu ringtone | composer ringtones
72.36.211.* 于 2007-04-26 18:14:49发表:
Great work!
free gospel ringtones | wav ringtones | verizon free ringtones | mobile ringtones | jamster ringtones | free nascar ringtones | motorola mp3 ringtones | free ringtones for t mobile | midi ringtones | free lg ringtones
72.36.211.* 于 2007-04-26 18:14:41发表:
Thank you!
cellular one ringtones | free music ringtones | free ringtones verizon | free ringtones for sprint | free ringtones downloads | free us cellular ring tones | download free ringtone | free us cellular ringtones | motorola keypress ringtones | free mp3 ringtones
72.36.211.* 于 2007-04-26 18:14:28发表:
Well done!
boost mobile ringtones | ringtones samsung | mp3 ringtones free | free midi ringtone | tmobile free ringtones | free alltel ringtones | free ringtones for motorola | ringtone mp3 | sprint phones | mosquito ringtone
72.36.192.* 于 2007-04-25 05:25:28发表:
Thank you!
best poker sites | play roulette | deposit bonus casino | no deposit online casinos | roulette game | play slots for free | world series poker | internet casino games | black jack free | play blackjack online
72.36.192.* 于 2007-04-25 05:24:58发表:
Great work!
free black jack games | free poker download | casino online | texas holdem free online | free poker games | texas holdem free | new casinos | sims slots | no deposit casinos | free blackjack games
72.36.192.* 于 2007-04-25 05:24:03发表:
Well done!
poker downloads | game slot | absolute poker | roulette online | no deposit casino bonuses | download blackjack | poker stars | free slot machines | free bonus slots | gambling online
72.36.192.* 于 2007-04-25 05:23:28发表:
Great work!
casino free game online | play money poker | strip blackjack free | cleopatra slots | free online video slots | poker game online | free casino | online poker usa | keno online | video slot games
72.36.192.* 于 2007-04-25 05:23:09发表:
Good design!
empire poker | casino game download | cleopatra slot machine | black jack game | free money no deposit | us poker sites | russian roulette games | texas holdem online | poker web sites | free casino slots
72.36.211.* 于 2007-04-24 10:04:16发表:
Well done!
video slot games | play blackjack free | play roulette free | pacific poker | games download | download free poker game | poker websites | roulette | free poker software | free slot machine games online
72.36.211.* 于 2007-04-24 10:03:34发表:
Good design!
texas holdem free | free black jack game | free online texas hold em | online poker free | free slots | internet blackjack | poker texas | casino free game online | free no download slots | online roulette game
72.36.211.* 于 2007-04-24 10:03:10发表:
Great work!
play bingo online | pai gow poker | black jack free | casino slots | casino open usa | casino games free | world poker | party poker | poker free download | slots of fun
72.36.211.* 于 2007-04-24 10:02:57发表:
Well done!
free online casinos | online black jack | poker game online | free casinos | blackjack online | poker for fun | slim slots | slots for fun | online gambling sites | download free poker
72.36.211.* 于 2007-04-24 10:02:46发表:
Great work!
free casino | online free roulette | free internet poker | gambling machines | games on line | free slot machine play | free monopoly online | casino online download | online bingo | download blackjack
220.184.114.* 于 2007-04-23 16:36:56发表:
GOOGLE左侧排名跟GOOGLE排名有什么区别,GOOGLE左侧排名又是什么：）
72.36.211.* 于 2007-04-22 12:33:25发表:
Great work!
casino on net | poker downloads | 3 card poker | casino games free | free online poker games | download poker | poker stars | poker usa | slot machine games free | free online bingo
72.36.211.* 于 2007-04-22 12:32:46发表:
Nice site!
poker sites | poker games online | free casino game | free poker download | internet blackjack | online slots | joker poker | free slots games | sim slots | play blackjack online