经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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
65.110.43.* 于 2006-12-21 07:17:34发表:
Well done!
poker rooms | no limit holdem | free blackjack game | online texas hold em | free slot | play free blackjack online | casino on line | poker usa open | online casinos | internet casino gambling online
65.110.43.* 于 2006-12-21 07:15:35发表:
Well done!
blackjack software | free online roulette | casino game | free online slots games | play free slot machines | free slot games online | free online bingo games | free casino | joker poker | online holdem
72.232.93.* 于 2006-12-21 07:14:44发表:
Good design!
new online casinos | gambling game | poker downloads | internet gambling | poker games online | money poker | black jack games | poker on line | free slot machine games | download free poker games
72.232.93.* 于 2006-12-21 07:14:18发表:
Great work!
omaha poker | poker tournament | no deposit casino | poker hold em | absolute poker | free online video slots | three card poker | online blackjack | casino game download | poker stars
65.110.43.* 于 2006-12-21 07:14:03发表:
Good design!
play casino games | poker for us players | texas holdem poker | free online blackjack | slim slots | free internet poker | strip black jack | free online slot machines | video slot machines | online bingo games
72.232.93.* 于 2006-12-19 20:37:57发表:
Great work!
roulette odds | world series of poker | free slots casino | casino bonus | draw poker | virtual poker | no deposit bonus casinos | poker cards | poker accept us | casino on line
72.232.93.* 于 2006-12-19 20:36:14发表:
Good design!
casinos with no deposit | free slot games | best internet poker | free three card poker | slot games | free slot play | no limit texas holdem | on line casinos | free money no deposit casinos | online slots free
65.110.43.* 于 2006-12-19 20:36:08发表:
Good design!
free online slots no download | free slot machines games | strip blackjack | on line gambling | online gambling | play free slot machines | play free blackjack | play internet poker online | free poker | free slots no download
65.110.43.* 于 2006-12-19 20:33:10发表:
Thank you!
poker club | online casino blackjack | poker card | video slots | free on line poker | blackjack games | video poker download | no deposit bingo online | black jack game | star poker
65.110.43.* 于 2006-12-19 20:32:45发表:
Good design!
best casinos | blackjack odds | noble poker | free online texas hold em | gambling online | game poker | online poker tournament | poker accepting americans | easy online real bingo | online poker reviews
72.232.92.* 于 2006-12-18 21:22:51发表:
Well done!
play free slots | casino no deposit | online poker sites | free casino games online | play bingo | no deposit bingo online | free online video slots | monopoly slots | free casinos | free slot machine games online
72.232.92.* 于 2006-12-18 21:21:43发表:
Well done!
aussie slots | free no deposit online casinos | free on line poker | free slot machine play | card game poker | stud poker | online casino blackjack | internet casino | poker accept usa | world poker tour
65.110.43.* 于 2006-12-18 21:20:58发表:
Great work!
free omaha poker | poker bonus | sims slots | play slot machines | poker directory | roulette free | caribbean stud poker | poker for free | online gambling casino | free casino games
65.110.43.* 于 2006-12-18 21:20:26发表:
Well done!
casino royale | blackjack free | easy online real bingo | monopoly online | real poker | casino online | full poker review tilt | free casino online | poker sites accept us | online video poker
72.232.93.* 于 2006-12-18 21:20:15发表:
Great work!
free blackjack game | free online roulette | caribbean poker | play free slot machine game | gambling games | play free blackjack | poker websites | star poker | casino games free | video poker machines
65.110.43.* 于 2006-12-17 20:51:18发表:
Well done!
star wars ringtones | free ringtones verizon | 3310 ringtones composer | nextel ringtones i730 free | free bollywood ringtones | free alltel ringtones | free lg ringtones | free ringtones for sprint | free cellular ringtones | converter mp3 ringtone t68i
72.232.92.* 于 2006-12-17 20:49:40发表:
Well done!
samsung ringtones | christian ringtones free praise | free nokia ringtone downloads | mobile phone ringtone | ringtones for nokia | v60i country ringtones | ringtones for sprint phones | nextel motorola i730 ringtones | cell phone ringtones | free cellphone ringtones
72.232.93.* 于 2006-12-17 20:47:48发表:
Good design!
nextel i730 country ringtones | motorola v60i free ringtones | download free sprint ringtones | mp3 ringtone | simpsons ringtone simpsons ringtone | 24 ringtone 24 ringtone | free polyphonic ringtone downloads | midi ringtones | free mobile ringtones | nextel i730 ringtones free
65.110.43.* 于 2006-12-17 20:47:05发表:
Great work!
free ringtones us cellular | i730 free nextel ringtones | free ringtone download | motorola ringtones free | motorola v60i keypress ringtones | downloadable free ringtones | 24 ctu ringtone verizon | free download nokia ringtones | free samsung ringtones | arabic ringtones
72.232.93.* 于 2006-12-17 20:46:45发表:
Well done!
harry potter ringtones | free ringtones for tracfone | composer motorola free ringtones | free cingular ringtones usa | free real ringtones | ctu ringtones | ringtone jukebox | hindi ringtone hindi ringtone | download free ringtone | cingular free ringtone siemens
65.110.43.* 于 2006-12-16 19:07:38发表:
Great work!
poker club | online bingo games | blackjack game | new online casinos | free blackjack games | free internet poker | casino online | slots online | free slots on line | best internet poker
65.110.43.* 于 2006-12-16 19:06:27发表:
Nice site!
free online poker games | free bingo | free money no deposit casinos | slot game | poker games | play poker usa | poker machines | online poker software | free online slots games | paradise poker review
65.110.43.* 于 2006-12-16 19:05:56发表:
Nice site!
online poker games | poker for fun | free games on line | free online video slots | blackjack software | play roulette | star poker | poker tour | noble poker | casinos online
72.232.93.* 于 2006-12-16 19:05:38发表:
Great work!
online casino bonus | play free video slots | online casinos | slot games free | best poker sites | playing roulette | strip blackjack | online gambling casino | online casino poker | online casino slots
65.110.43.* 于 2006-12-16 19:05:22发表:
Good design!
poker room | multi player poker | online poker usa | internet bingo | gambling games | gambling on line | free casino slots | play slot machines | online holdem | poker review
65.110.43.* 于 2006-12-15 19:00:41发表:
Well done!
internet gambling | blackjack free games | card poker | live poker rooms | slot games | blackjack game | free casino games | free slot games | poker hand | download poker games
65.110.43.* 于 2006-12-15 18:59:35发表:
Good design!
playing poker | new no deposit online casinos | casino free games | poker websites | play blackjack online | free online bingo games | online poker sites | star poker | internet casino poker | uk poker
72.232.93.* 于 2006-12-15 18:58:52发表:
Well done!
free money casinos | gambling on line | casino download | online roulette | roulette free | free slot machine games | joker poker | world series of poker download | poker machines | best internet poker
65.110.43.* 于 2006-12-15 18:58:24发表:
Nice site!
free 3 card poker | casino royale | free black jack | online casino bonus | free online slot games | online texas hold em | free on line games | free poker game download | free fun slots | texas holdem tournament
65.110.43.* 于 2006-12-15 18:58:08发表:
Great work!
blackjack online free | absolute poker | free joker poker | blackjack software | aussie slots | poker card | free online texas holdem | free bingo | flash casinos | free no download slots
72.232.93.* 于 2006-12-14 19:49:59发表:
Well done!
free download poker | play internet poker online | poker us welcome | casino game online | texas poker | best casino online | free poker downloads | download casino | 3 card poker | online casino poker
65.110.43.* 于 2006-12-14 19:48:18发表:
Thank you!
slot online | free casino money | paradise poker review | new no deposit casinos | free cash casinos | free online poker games | monopoly slots | three card poker | blackjack online free | play online poker
65.110.43.* 于 2006-12-14 19:47:14发表:
Nice site!
casino bonus | slots for fun | black jack game | free play slots | monopoly slot machine | play slot machines | free games on line | free bingo games | free poker software | online paigow poker
72.232.92.* 于 2006-12-14 19:46:34发表:
Good design!
free slot | free blackjack | online texas holdem | free slot machine play | play free slot machine game | online poker us | online gambling holdem | planet poker | online texas hold em | free casino slots
65.110.43.* 于 2006-12-14 19:46:10发表:
Good design!
poker hand | poker cards | online gambling | games slots | online poker games | stud poker | free slots for fun | bingo cards | texas holdem | earn cash playing poker
65.110.43.* 于 2006-12-13 19:31:04发表:
Well done!
blackjack odds | keno | free blackjack game | online video poker | slot game | free casino | poker gambling | free online slot machine games | free bonus slots | internet casino poker
65.110.43.* 于 2006-12-13 19:29:50发表:
Well done!
video poker download | casino poker | online black jack | free casino games online | slot machines | holdem poker texas | no deposit online casinos | free games on line | free online bingo | online gaming
72.232.93.* 于 2006-12-13 19:28:20发表:
Thank you!
casinos with no deposit | free multi line slots | free online blackjack | play roulette | blackjack game | poker sites accept us | free slots for fun | poker games | poker us | free casino money
72.232.93.* 于 2006-12-13 19:27:39发表:
Thank you!
poker tour | no limit holdem | free online casino games | free roulette | free three card poker | online casino blackjack | poker party | monopoly slot machine | poker machines | free slots no download
65.110.43.* 于 2006-12-13 19:27:21发表:
Well done!
texas poker | free poker sites | poker review star | poker stars download | free blackjack | world series of poker | free casino games | slot machine | poker game online | party poker bonus