经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.232.63.* 于 2007-02-06 16:32:59发表:
Well done!
free poker download | casino download | slot machine free | new free money online casinos | play money poker | free games on line | free on line poker | online free blackjack | download party poker | no deposit casino bonus
72.232.63.* 于 2007-02-06 16:31:56发表:
Thank you!
free slots game | free blackjack online | play roulette online | on line casinos | free casino bonus | no limit texas hold em | slots of fun | gambling sites | russian roulette game | poker stars download
65.110.43.* 于 2007-02-06 16:31:04发表:
Great work!
online strip blackjack | free online games | poker software | free poker software | free slot machine game | slot machine games | download free poker games | strip black jack | online bingo | free casino slot games
72.232.63.* 于 2007-02-06 16:30:43发表:
Great work!
casino on line | free casinos | download poker | free slots no downloads | free monopoly slots | texas hold em free | free poker on line | no deposit bonus | texas hold em | games slots
65.110.43.* 于 2007-02-06 16:30:30发表:
Well done!
free online video slots | play blackjack | strip blackjack online | free casino games | free gambling | keno online | free sims slots | slot machines games | roulette free games | free slot machines games
72.232.63.* 于 2007-02-05 17:15:07发表:
Good design!
24 ringtone 24 ringtone | free christian ringtones sprint | free polyphonic ringtone download | v60i country ringtones | convert mp3 to ringtone | download samsung ringtones | ringtones for nextel | ringtones for tracfone | crazy frog ringtones | free polyphonic ringtones motorola
72.232.250.* 于 2007-02-05 17:14:37发表:
Good design!
free boost mobile ringtones | crazy frog ringtone | free nokia poly ringtone | free anime ringtones | free ringtone for motorola | cingular wireless ringtones | music ringtones | downloadable free ringtones | free ringtones 4 samsung | compose motorola ringtones
65.110.43.* 于 2007-02-05 17:14:08发表:
Thank you!
cingular phone free ringtones | polyphonic ringtone | i730 mp3 nextel ringtone | free ringtones for lg | free cingular ringtones usa | ringtones for nokia | free sms ringtones | alltel cell phone ringtones | christian ringtones free praise | free ringtones cingular
72.232.63.* 于 2007-02-05 17:13:52发表:
Great work!
ringtone creator | 24 ringtones | downloads free mp3 ringtone | i730 nextel ringtone | nextel ringtone | sprint sanyo free ringtones | free ringtone downloads | free suncom ringtones | free nextel ringtone downloads | polyphonic ringtones
65.110.43.* 于 2007-02-05 17:13:38发表:
Nice site!
ringtone jukebox ringtone jukebox | free composer ringtones | free ringtones verizon | free real music ringtones | free logos ringtones | sprint ringtones | nextel i730 ringtones | download free sprint ringtones | free cellular ringtones | nextel i730 music ringtones
72.232.63.* 于 2007-02-04 19:59:53发表:
Well done!
free sprint ringtones | free download nokia ringtones | wwe ringtones | motorola v265 mp3 ringtones | midi ringtone | ringtones cingular | download ringtones | free bollywood ringtones | free ringtones for cingular | polyphonic ringtones free
65.110.43.* 于 2007-02-04 19:59:23发表:
Well done!
free us cellular ringtones | 24 ctu ringtone | free ringtones 4 samsung | motorola free ringtones | star wars ringtones | ringtone jukebox ringtone jukebox | free ringtone | free nokia ringtone downloads | free ringtone download | free mobile phone ringtone
65.110.43.* 于 2007-02-04 19:58:43发表:
Good design!
cingular ringtones | nextel i730 ringtone downloads | cisco voice ip ringtones | sprint pcs ringtones | polyphonic ringtones | nextel i730 country ringtones | christian music ringtones | free sanyo sprint ringtones | free harry potter ringtones | verizon ringtones
72.232.250.* 于 2007-02-04 19:58:15发表:
Great work!
classical music ringtones | nokia ringtone | i730 free nextel ringtones | composer hindi ringtone | mp3 ringtone | free motorola keypress ringtones | jamster ringtones | cellular one motorola ringtones | free nextel i730 ringtones | free logos ringtones
72.232.63.* 于 2007-02-04 19:58:01发表:
Good design!
tracfone ringtones | i830 nextel ringtone software | free downloadable ringtones | ringtone converter | free ringtones for alltel | real music ringtones | free lg ringtones | free ringtones for sprint | download mp3 music ringtone | nextel i730 wav ringtones
72.232.250.* 于 2007-02-03 12:54:01发表:
Good design!
free blackjack online | play bingo | free slot | sims slots | free slots on line | poker sites | play texas holdem online | hold em poker | poker games | play free blackjack
72.232.63.* 于 2007-02-03 12:53:42发表:
Thank you!
roulette game | free online video slots | no deposit casino bonus | poker free download | play slot machines | poker | no deposit online casino | games online | free play slot machines | poker software
72.232.250.* 于 2007-02-03 12:53:21发表:
Nice site!
free texas hold em | cleopatra slots | roulette free games | texas hold em poker | play slots for fun | free poker on line | blackjack download | online black jack | free roulette | strip blackjack free
65.110.43.* 于 2007-02-03 12:52:54发表:
Great work!
bingo online | download casino games | online casino games | online slot games | party poker download | slot machines games | casino no deposit | play texas holdem free | free on line slots | internet casinos
72.232.63.* 于 2007-02-03 12:52:21发表:
Great work!
keno online | free games online | free texas holdem poker | internet gambling | slots download | cleopatra slot machine | virtual poker | free roulette online | free games on line | aussie slots
72.232.250.* 于 2007-02-02 13:18:06发表:
Good design!
internet blackjack | online casino bonus | free online video slots | roulette games | free casino slot games | play poker | play free blackjack online | online poker usa | poker stars download | free online strip blackjack
72.232.250.* 于 2007-02-02 13:17:36发表:
Good design!
free bonus slots | download casino games | play bingo | strip blackjack | play blackjack online | online roulette free | free bingo games | free online slot games | casino game | joker poker
65.110.43.* 于 2007-02-02 13:16:58发表:
Thank you!
free online poker | virtual poker | slot machine software | world poker | no download slots | strip black jack | texas hold em free | poker texas holdem | black jack games | download poker game
65.110.43.* 于 2007-02-02 13:16:36发表:
Well done!
free sims slots | world series of poker | internet casinos | games on line | blackjack games | play free slots | free slots | free online casino | black jack game | online casino games
65.110.43.* 于 2007-02-02 13:16:16发表:
Good design!
free online slots no download | black jack | video poker | casino online | free monopoly online | free slot | pai gow poker | three card poker | free slot game | caribbean stud poker
65.110.43.* 于 2007-02-01 12:42:34发表:
Thank you!
ringtones for cingular | free ringtones for nokia | motorola v60i free ringtones | cell phone download ringtones | free sprint sanyo ringtones | sprint sanyo 8100 ringtones | free verizon ringtones | 24 ctu ringtone verizon | nextel i730 wav ringtones | free ringtones for lg
65.110.43.* 于 2007-02-01 12:41:42发表:
Great work!
free mp3 ringtone downloads | download free music ringtone | free blackberry ringtones | v60i motorola ringtones | download free sprint ringtones | motorola 120c free ringtones | free polyphonic ringtone downloads | download free mp3 ringtones | free ringtone downloads | nextel i730 ringtones
65.110.43.* 于 2007-02-01 12:40:41发表:
Thank you!
free ringtones 4 samsung | free motorola i730 ringtones | free polyphonic ringtones | free ringtones for alltel | ringtone jukebox ringtone jukebox | free nextel ringtones | ringtone downloads ringtone downloads | downloadable free ringtones | download samsung ringtones | ringtones for tracfone carriers
72.232.250.* 于 2007-02-01 12:39:50发表:
Great work!
free boost mobile ringtones | polyphonic ringtone | free anime ringtones | free us cellular ringtones | nextel i730 ringtone downloads | free polyphonic motorola ringtones | free motorola ringtone downloads | free mobile ringtones | real music ringtones | nextel wav i730 ringtones
65.110.43.* 于 2007-02-01 12:39:04发表:
Great work!
free i830 nextel ringtones | free motorola v60i ringtones | free audiovox ringtones | i730 free nextel ringtones | v60i country ringtones | cheap ringtones | nextel ringtones | free bollywood ringtones | free kyocera ringtones | free ringtone converter
72.232.93.* 于 2007-01-31 12:39:57发表:
Nice site!
casino poker | play slot machines for free | casino slots | online black jack | online gambling sites | online roulette free | slots for free | free online casino | roulette download | on line casinos
72.232.93.* 于 2007-01-31 12:39:36发表:
Thank you!
monopoly slot machine | casino games free | free casino slots | three card poker | pacific poker | online games | slim slots free | roulette games | slot machine games | free three card poker
72.232.250.* 于 2007-01-31 12:38:24发表:
Well done!
no download slots | multiplayer poker | slot machine game | poker online free | casino games online | slots download | free slots for fun | online free poker | online poker game | poker stars
65.110.43.* 于 2007-01-31 12:37:52发表:
Nice site!
free slot machine | bingo online | download poker | free 3 card poker | keno | russian roulette game | free poker games | sims free slots | online poker free | free no deposit casinos
65.110.43.* 于 2007-01-31 12:37:14发表:
Good design!
flash casino games | blackjack for free | online slot games | strip blackjack online | strip blackjack games | play slot machines | aussie slots | slot game | download casino games | sim slots
65.110.43.* 于 2007-01-30 14:11:46发表:
Good design!
free on line slots | online bingo | poker stars | free video slot games | free video poker | black jack | free poker websites | free online bingo | casino online | video poker machines
72.232.250.* 于 2007-01-30 14:10:40发表:
Good design!
online roulette free | free casino downloads | casinos on line | free no download slots | free money casinos | free online strip blackjack | texas holdem free | free texas hold em | cleopatra slots | no deposit bingo
65.110.43.* 于 2007-01-30 14:10:04发表:
Thank you!
no deposit casino bonus | casino free | free play slots | free slots | free online texas hold em | play roulette for free | free slot machine game | texas hold em poker | casino game | free games on line
65.110.43.* 于 2007-01-30 14:09:31发表:
Good design!
free blackjack games | blackjack online free | play online poker | us poker sites | free slots | free internet poker | poker for free | game slot | games download | video poker free
72.232.250.* 于 2007-01-30 14:09:12发表:
Nice site!
party poker | poker for fun | free casino games online | three card poker | slot machine game | free monopoly online | poker | no deposit casinos | free online slots no download | free slot downloads