经常发现一些网友问分析函数的问题，虽然分析函数比较多，有一些分析函数也确实比较难以理解，会给初学者有很大的心理压力，其实对于大部分的分析函数，一般都不会有机会用到，所以掌握常用的几个分析函数就可以啦。
常用的分析函数如下所列:
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.93.* 于 2006-12-04 18:54:59发表:
Good design!
playing poker | new no deposit casinos | free money casinos | online slot machines | online texas holdem | no deposit casino | poker game online | free slots casino | keno games | pai gow poker
65.110.43.* 于 2006-12-04 18:54:20发表:
Thank you!
free bingo cards | poker card game | free online blackjack | poker tournament | no deposit online casinos | poker rooms accept us | multiplayer poker | video slot games | online black jack | online casino bonus
65.110.43.* 于 2006-12-04 18:53:59发表:
Nice site!
casino free games | play blackjack | free on line games | play free slots online | online gaming casinos | joker poker | no download games | roulette odds | accept us poker players | free slot machine downloads
65.110.43.* 于 2006-12-04 18:53:45发表:
Well done!
free online texas holdem | free slots for fun | online gambling games | casino poker | russian roulette game | strip blackjack | paradise poker | texas hold em poker | casino games free | black jack game
65.110.43.* 于 2006-12-03 19:06:26发表:
Good design!
free poker online | casino slot machine | no limit hold em | aussie slots | casino bonus | free poker game | play poker for free | free on line slots | money poker | no deposit online casinos
65.110.43.* 于 2006-12-03 19:05:28发表:
Good design!
online blackjack | free online roulette | video poker download | paigow poker | internet casino | free poker tournaments | monopoly slot machine | play roulette | texas holdem tournament | poker sites
72.232.250.* 于 2006-12-03 19:04:44发表:
Great work!
planet poker | poker stars download | slim slots | texas holdem online | casino game online | slots for fun | online poker rating room | black jack game | poker review star | poker games online
65.110.43.* 于 2006-12-03 19:04:22发表:
Great work!
internet casino gambling | online poker game | poker usa | poker stars | gambling online | texas holdem poker | poker web sites | caribbean poker | free internet poker | online roulette
65.110.43.* 于 2006-12-03 19:04:07发表:
Great work!
on line gambling | free casinos | download free poker games | blackjack online free | texas holdem poker online | poker game free | monopoly slots | free slot machines games | free casino games online | no deposit casinos
65.110.43.* 于 2006-11-30 08:25:52发表:
Thank you!
slot machine software | free black jack games | monopoly online | world poker tour | holdem poker online | online slots | poker gambling | free no deposit online casinos | casino no deposit | free texas holdem poker
72.232.250.* 于 2006-11-30 08:14:55发表:
Good design!
slot game | texas holdem | play internet poker online | omaha poker | free poker software | free slots games | online bingo | no download games | poker us welcome | internet casino gambling
65.110.43.* 于 2006-11-30 08:03:48发表:
Great work!
texas hold em poker online | poker game online | play slots | poker texas holdem | real poker | casino online games | casino online | free blackjack game | slot online | online poker tournament
65.110.43.* 于 2006-11-30 07:53:01发表:
Nice site!
gambling poker | free online casinos | poker usa open | no deposit casino | card game poker | joker poker | online gambling games | free blackjack online | casino portal | play money poker
72.232.250.* 于 2006-11-30 07:45:41发表:
Great work!
best casinos | play poker on line | no limit hold em | online casino games | texas holdem free | strip blackjack | slots games | play roulette | poker accept us | internet bingo
72.36.178.* 于 2006-11-29 12:48:56发表:
Great work!
My homepage | Cool site