经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.92.* 于 2006-12-12 19:47:37发表:
Great work!
roulette download | no limit hold em | roulette game | free blackjack online | free roulette games | cleopatra slot machine | new online casinos | no limit texas holdem | free play slot machines | online gaming
65.110.43.* 于 2006-12-12 19:46:14发表:
Good design!
empire poker | free casino cash | sim slots | free online blackjack | world poker | joker poker | free slots on line | free slots casino | download free poker games | poker pages
65.110.43.* 于 2006-12-12 19:45:34发表:
Good design!
online poker us | poker online | free slots online | free bonus slots | play poker on line | star poker | free poker sites | keno online | playing poker | 3 card poker
72.232.92.* 于 2006-12-12 19:45:23发表:
Good design!
playing roulette | gambling on line | texas holdem online | free online casinos | texas hold em | free money no deposit casinos | free slot machine games online | poker hold em | poker tournament | caribbean poker
72.232.93.* 于 2006-12-12 19:44:41发表:
Good design!
strip blackjack | flash casinos | free online bingo games | online poker rating room | holdem poker texas | free slot play | internet poker | poker websites | blackjack odds | poker room rating
72.232.93.* 于 2006-12-11 20:00:38发表:
Great work!
video slot machines | best online casinos | free slot machine games | free casino slot games | free no download slots | online black jack | paradise poker | free poker tournaments | casinos with no deposit | free online video slots
65.110.43.* 于 2006-12-11 19:58:49发表:
Nice site!
blackjack game | free poker software | free slot machine downloads | poker games | play blackjack | texas hold em poker | poker online | online gambling | slots for free | download party poker
65.110.43.* 于 2006-12-11 19:57:09发表:
Nice site!
roulette free games | monopoly slot machine | poker games online | play roulette | texas holdem online | play free slots online | best internet poker | star poker | poker sites | internet casino gambling
65.110.43.* 于 2006-12-11 19:56:32发表:
Nice site!
free slots no download | gambling poker | online slots | on line gambling | roulette game | free bingo cards | on line casinos | poker party | no deposit bingo online | play internet poker online
65.110.43.* 于 2006-12-11 19:56:09发表:
Well done!
strip blackjack | free download poker | free online slots no download | online casino poker | free on line poker | online gambling casino | video poker free | free slot machine play | casino download | free poker on line
65.110.43.* 于 2006-12-10 18:02:24发表:
Thank you!
online video poker | free poker game | video slot games | keno | casino games | crazy game of poker | free blackjack online | free on line slots | poker cards | online poker rating room
72.232.93.* 于 2006-12-10 18:01:02发表:
Great work!
online holdem | draw poker | free slot games | poker site | black jack game | free joker poker | free online poker game | sims free slots | poker for us players | bonus poker
72.232.92.* 于 2006-12-10 18:00:13发表:
Good design!
casinos on line | texas hold em | pacific poker | no deposit casinos | free roulette online | online casino games | poker free | poker web sites | free casino slots | texas hold em poker
72.232.92.* 于 2006-12-10 17:59:51发表:
Nice site!
gamble poker | gambling poker machine | poker card game | online slots free | free internet poker | poker hold em | play black jack | slots online | play texas holdem | no download games
65.110.43.* 于 2006-12-10 17:59:34发表:
Nice site!
poker games free | blackjack online | play poker on line | play bingo online | free online casinos | poker pages | roulette game | free casino online | poker sets | poker texas hold em
72.232.250.* 于 2006-12-09 20:24:44发表:
Good design!
casinos with no deposit | texas holdem tournament | multiplayer poker | free money no deposit casinos | black jack | free gambling games | casino slots | free online slot machine games | black jack download | free online casino games
65.110.43.* 于 2006-12-09 20:23:36发表:
Well done!
poker review | sims slots | online poker rooms | slots for free | free poker sites | cleopatra slots | internet poker game | monopoly slots | play roulette online | roulette online
65.110.43.* 于 2006-12-09 20:22:56发表:
Good design!
free slot machine | free joker poker | casino royale | games slots | play money poker | strip blackjack | casino bonus | holdem poker | black jack game | free online strip blackjack
65.110.43.* 于 2006-12-09 20:22:36发表:
Nice site!
poker sites accept us | gambling game | download poker games | no deposit casino | free three card poker | online black jack | poker money | blackjack online | accept us poker players | internet bingo
65.110.43.* 于 2006-12-09 20:22:21发表:
Well done!
free play slot machines | free online poker game | earn cash playing poker | keno online | free online casino slots | best poker sites | game poker | cleopatra slot machine | poker room | world series poker
65.110.43.* 于 2006-12-08 19:23:54发表:
Good design!
free roulette | gambling sites | casino game download | bingo games | no deposit casino | play texas holdem | multiplayer poker | free online roulette | play slot machines | play free slot machines
72.232.93.* 于 2006-12-08 19:22:38发表:
Great work!
casino games free | online casino poker | games slots | full tilt poker | gamble poker | free money casinos | free poker game download | poker games free | play money poker | free blackjack online
65.110.43.* 于 2006-12-08 19:22:00发表:
Thank you!
free three card poker | slots for fun | poker accept usa | black jack game | online poker us | free online slots games | texas hold em poker online | internet poker room | aussie slots | best internet poker
65.110.43.* 于 2006-12-08 19:21:44发表:
Well done!
play free cleopatra slots online | slots on line | blackjack online free | casino slot machine | no limit hold em | 10 best online casinos | free omaha poker | video poker free | poker machines | free money casino
65.110.43.* 于 2006-12-08 19:20:58发表:
Thank you!
free slot downloads | casino portal | caribbean poker | free bingo games | planet poker | casino poker | online black jack | cleopatra slots | poker rooms | roulette free
65.110.43.* 于 2006-12-07 21:15:01发表:
Thank you!
free multi line slots | blackjack online | free online blackjack | on line gambling | play blackjack free | online slot machines | best casino online | roulette free games | internet poker game | online slots
65.110.43.* 于 2006-12-07 21:13:58发表:
Nice site!
online gambling games | best internet poker | blackjack game | poker hold em | casino slots | world series of poker download | easy online real bingo | casinos with no deposit | play bingo online | play roulette online
65.110.43.* 于 2006-12-07 21:13:26发表:
Well done!
poker accept us | full poker review tilt | free casino slot games | poker review | texas holdem free | texas holdem | three card poker | paradise poker review | free online bingo | poker room review
65.110.43.* 于 2006-12-07 21:13:02发表:
Great work!
party poker | empire poker | poker card | no download slots | free slots games | poker texas hold em | free roulette games | poker tournament | world series poker | poker usa open
65.110.43.* 于 2006-12-07 01:02:41发表:
Good design!
free slots games | casino online games | texas holdem poker online | poker gambling | play slot machines for free | online paigow poker | poker stars | play poker game | virtual poker | online poker room
65.110.43.* 于 2006-12-07 01:01:38发表:
Well done!
free no deposit online casinos | download casino | playing roulette | poker us | play online poker | texas holdem tournament | play roulette online | black jack online | crazy game of poker | play free blackjack
65.110.43.* 于 2006-12-07 01:00:30发表:
Great work!
party poker | online poker review room | blackjack odds | online poker | free on line slots | internet gambling | poker card game | play free slot machines | online poker accept us | free online poker game
65.110.43.* 于 2006-12-07 00:59:58发表:
Well done!
free money casinos | play money poker | free slots for fun | slots online | poker pages | poker game online | gambling machines | best online poker room | black jack game | new online casinos
65.110.43.* 于 2006-12-07 00:59:39发表:
Nice site!
internet poker | poker for fun | hold em poker | free bingo cards | free fun slots | online holdem | free joker poker | no limit hold em | free no deposit casinos | internet poker game
65.110.43.* 于 2006-12-05 18:48:21发表:
Good design!
play free slot machine game | monopoly slots | roulette odds | free casino bonus | poker sets | video poker download | poker review star | free casino slot games | casino bonus | russian roulette game
65.110.43.* 于 2006-12-05 18:47:30发表:
Well done!
internet blackjack | online video poker | play free blackjack | on line gambling | free online texas hold em | free slot downloads | online gaming | full tilt poker | omaha poker | download party poker
72.232.250.* 于 2006-12-05 18:47:00发表:
Great work!
free games on line | poker rooms accept us | no download casino | online casino poker | free online casino games | poker card | poker stars download | video poker machines | play poker usa | online poker rating room
72.232.250.* 于 2006-12-05 18:46:43发表:
Nice site!
free casino slots | slot online | online poker sites | roulette online | play roulette online | free slots online | texas holdem free | gambling online | aussie slots | free video slots
72.232.250.* 于 2006-12-05 18:46:30发表:
Nice site!
free slots download | internet casino | online texas holdem | live poker | multiplayer poker | casino poker | new no deposit online casinos | world poker | slot game | flash casino games
72.232.250.* 于 2006-12-04 18:55:46发表:
Great work!
play free cleopatra slots online | free online casino games | slots for free | poker card | free casino downloads | free video slots | 3 card poker | play blackjack online | download poker games | poker club