经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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-08 07:20:00发表:
Thank you!
download free nokia ringtone | us cellular ring tones | ringtones for verizon | free lg ringtones | free cellphone ringtones | free real ringtones for cingular | ringtone uploader | tmobile free ringtones | free monophonic ringtones | crazy frog ring tone
72.36.192.* 于 2007-05-08 07:19:41发表:
Well done!
keypress ringtones | nextel ringtone program | free cell phone ringtones | free anime | free polyphonic | free harry potter ringtones | free ringtone converter | ringtone 24 | nokia downloads | free samsung ringtones
72.36.192.* 于 2007-05-08 07:19:13发表:
Well done!
sprint phones | free ringtones for verizon | free wwe ringtones | absolutely free ringtones | free centennial wireless ringtones | free midi ringtone | ringtones samsung | polyphonic ringtone | free ringtones for sprint phones | sms ringtones
217.211.123.* 于 2007-05-08 04:13:46发表:
52cc187bc6ce6fff9bdb9a0bedff08cd http://modulistica-associazione-sportiva-cinque-mille.vuulyy.net/ http://alfa-feto-proteina-valore-riferimento.bhjrbx.info/ http://testo-canzone-tarzan-inglese-disney.cbcmld.info/ http://gazzetta-sport-17-giornata-campionato.tpuskc.net/ http://sindrome-alienazione-genitoriale-or-parentale.drlrmm.info/ http://linguaggio-verbale-e-non-verbale.tpuskc.net/ http://solo-foto-sesso-gratis-donna-matura.aqnfrs.info/ http://ma-c-perequazione-pensione-2007.vuulyy.net/ http://orari-centro-commerciale-il-vulcano.bhjrbx.info/ http://film-porno-in-rete-com.cbcmld.info/ 26ebd8669f82ff2d680fe0e97ba7427c
125.120.137.* 于 2007-05-07 08:34:20发表:
UPS电源。。
buy christmas tree。。
cheap christmas gift。。
cheap christmas lights。。
布氏硬度计。。
测厚仪。。
测量投影仪。。
测温仪。。
测振仪。。
超净工作台。。
超声波测厚仪。。
超声波清洗器。。
超声波探伤仪。。
磁粉探伤仪。。
粗糙度仪。。
低温槽。。
直流电机。。
72.36.192.* 于 2007-05-07 06:39:48发表:
Nice site!
nokia free ringtones | free ringtone downloads | tmobile ringtones | free blackberry ringtones | mp3 to ringtone | verizon ringtones | cingular wireless ringtones | ringtones for verizon | cricket ringtones | download free ringtones
72.36.192.* 于 2007-05-07 06:39:16发表:
Well done!
ringtone mp3 | 24 ring tones | free ringtones for nextel | harry potter ringtone | free sprint ringtones | free ringtones for motorola | free mp3 ringtone | funny ringtones free | downloadable ringtones | verizon free ringtones
72.36.192.* 于 2007-05-07 06:38:43发表:
Great work!
ringtones for nextel | free bollywood ringtones | razr ringtones | free downloadable ringtones | free ringtones for t-mobile | sony ericsson ringtones | free ringtone converter | ringtone motorola | free composer ringtones | gospel ringtones
72.36.192.* 于 2007-05-07 06:38:26发表:
Thank you!
nokia ringtones | ringtones for motorola | ringtone uploader | free cellular one ringtones | sanyo ringtones | ringtones midi | free mp3 ringtone download | ctu ringtones | ringtone ctu | free harry potter ringtones
72.36.192.* 于 2007-05-07 06:37:54发表:
Good design!
cheap ringtones | free ctu ringtone | tracfone free ringtones | ctu ring tone | christian music ringtones | free 24 ringtones | crazy frog ringtones | free ringtones for t mobile | free suncom ringtones | wav ringtones
125.120.137.* 于 2007-05-06 14:53:36发表:
wow gold Buy wow gold--cheapwow gold.
well as wow gold and a place to buy wow gold please review. wow gold...
72.36.192.* 于 2007-05-06 07:09:59发表:
Well done!
free online poker games | free slot machines | bonus casino free online | poker for free | blackjack online | slot games | online games | free casino games online | black jack online | free online roulette
72.36.192.* 于 2007-05-06 07:09:29发表:
Good design!
casino free | poker games online | poker for fun | no deposit online casino | texas holdem free online | online free blackjack | play poker online | online poker game | free joker poker | blackjack download
72.36.192.* 于 2007-05-06 07:08:55发表:
Good design!
free online bingo games | download poker | free online casino games | download party poker | russian roulette game | hold em poker | slots for free | black jack game | free slot machine | free strip blackjack
72.36.192.* 于 2007-05-06 07:08:37发表:
Nice site!
roulette games | play slots for free | online roulette | online casinos | online texas holdem | free video | free slot | strip blackjack games | free poker software | download poker games
72.36.192.* 于 2007-05-06 07:08:03发表:
Great work!
poker games free | free casinos | free online slots games | play free slot machines | play slots | poker free download | free casino slots | poker game online | texas poker | games download
72.36.192.* 于 2007-05-05 07:36:53发表:
Great work!
blackjack free games | play poker online | black jack games | download blackjack | free poker | free slot machine | free sims slots | internet casino | texas holdem free online | free slot machine downloads
72.36.192.* 于 2007-05-05 07:36:02发表:
Well done!
download free poker games | free fun slots | world poker | casino games free | free poker on line | internet bingo | casino bonuses | play texas holdem free | video slots free | free slots downloads
72.36.192.* 于 2007-05-05 07:35:40发表:
Nice site!
free online black jack | free roulette | free online casino games | flash casinos | online black jack game | gambling online | free slots no download | bingo games | download party poker | new casinos
72.36.192.* 于 2007-05-05 07:35:28发表:
Good design!
slots on line | online casinos | video poker | free monopoly online | caribbean poker | online gambling sites | slot machine | casino bonus | online slot games | poker games free
72.36.192.* 于 2007-05-05 07:35:15发表:
Well done!
online poker usa | casino black jack | poker for free | free poker download | play roulette | free slot machine games | blackjack for free | poker download | casino online | no deposit casino
72.36.192.* 于 2007-05-04 08:03:46发表:
Great work!
ringtones for tracfones | 24 ctu ringtone | composer ringtones | polyphonic ringtone | motorola mp3 ringtones | free real ringtones for cingular | free hifi ringtones | free samsung ringtones | ringtone ctu | nokia free download
72.36.192.* 于 2007-05-04 08:02:54发表:
Great work!
free ctu ringtone | sprint pcs ringtones | samsung ringtones | free 24 ctu ringtone | ringtones for tracfone | motorola ringtones | blackberry ringtones | kyocera ringtones | lg ringtones | free sanyo ringtones
72.36.192.* 于 2007-05-04 08:02:35发表:
Good design!
free wwe ringtones | mp3 to ringtone converter | free mp3 download | centennial wireless ringtones | free cingular real ring tone | crazy frog ring tone | jamster ringtones | cricket free ringtones | free cellular one ringtones | ringtones
72.36.192.* 于 2007-05-04 08:02:23发表:
Well done!
nokia ringtones | free blackberry ringtones | free star wars ringtones | free anime ringtones | ringtone motorola | ringtones midi | download free ringtones | free ringtones for alltel | free monophonic ringtones | ctu ringtone verizon
72.36.192.* 于 2007-05-04 08:02:14发表:
Good design!
downloadable ringtones | 24 ringtone | sprint phones | ringtones download | free wav ringtones | free us cellular ring tones | country ringtones | boost mobile ringtones | free tmobile ringtones | verizon ringtones free
72.36.192.* 于 2007-05-03 07:35:37发表:
Great work!
play bingo | play slot machines | play poker for free | free online slot machine | best online casinos | new no deposit casino | free poker on line | online free slots | free blackjack online | no deposit casino bonus
72.36.192.* 于 2007-05-03 07:34:41发表:
Good design!
play poker online | best poker sites | roulette online | play slots | free slot downloads | poker stars | free cleopatra slots | free no deposit casinos | roulette game | play texas hold em
72.36.192.* 于 2007-05-03 07:34:13发表:
Thank you!
free video poker | free on line slots | strip blackjack games | hold em poker | online texas hold em | online bingo games | no download slots | roulette download | free games online | no deposit casino bonuses
72.36.192.* 于 2007-05-03 07:34:00发表:
Nice site!
slot machines | online roulette game | free poker games | texas holdem free online | slot games free | world poker | free money no deposit | free gambling | free casino bonus | blackjack games
72.36.192.* 于 2007-05-03 07:33:49发表:
Nice site!
free internet poker | casino open usa | poker for fun | no deposit casinos | bonus casino free online | blackjack online | free casino slots | play blackjack | blackjack free | black jack games
72.36.192.* 于 2007-05-02 08:11:28发表:
Well done!
ringtone jukebox | samsung free ringtones | sprint pcs ringtones | free ringtones for t mobile | free hi fi ringtones | free blackberry ringtones | free polyphonic ringtone | centennial ringtones | mp3 ringtone converter | motorola mp3 ringtones
72.36.192.* 于 2007-05-02 08:11:02发表:
Good design!
nextel downloads | verizon ctu ringtone | ringtones for us cellular | ringtones for tracfone | download free motorola ringtone | midi ringtones | free lg ringtones | nokia downloads | christian music ringtones | free ringtones for suncom
72.36.192.* 于 2007-05-02 08:10:45发表:
Thank you!
ringtones cingular | us cellular free ringtones | sprint phones | free cellular one ringtones | ringtones for cingular | free funny ringtones | alltel free ringtones | free centennial wireless ringtones | 24 ringtone free | ring tones
72.36.192.* 于 2007-05-02 08:10:34发表:
Thank you!
ringtone motorola | cingular ringtones | tmobile ringtones | free wav ringtones | cricket free ringtones | free ring tones | free mp3 ringtone | download free ringtone | ctu ringtone | cellular south ringtones
72.36.192.* 于 2007-05-02 08:10:21发表:
Nice site!
download free polyphonic ringtones | cellphone ringtones | free hifi ringtones | ringtone websites | free monophonic ringtones | free cell phone ringtones | ringtones mp3 free | razr v3 ringtones | star wars ringtone | country music ringtones
72.36.192.* 于 2007-05-01 08:11:57发表:
Thank you!
free slots | texas hold em poker | casino download | games download | casino bonuses | online holdem | poker stars download | free on line slots | free casinos | free online bingo
72.36.192.* 于 2007-05-01 08:11:18发表:
Good design!
free online games | free blackjack | slots games | slots of fun | free online casino slots | free poker money | texas holdem poker | fun slots | on line poker | online casino bonus
72.36.192.* 于 2007-05-01 08:10:55发表:
Great work!
online texas holdem | play roulette for free | casino games free | party poker download | free bonus slots | casino free | 3 card poker | free online slots no downloads | casino online | free casino slots
72.36.192.* 于 2007-05-01 08:10:43发表:
Thank you!
strip blackjack games | online poker game | poker web sites | blackjack game | poker usa | strip blackjack game | keno online | slot machine free | free casino bonus | free gambling