Oracle分析函数详
http:///html/article/database/oracle/20081216/14775_4.html
http://203.208.39.132/search?q=cache:TJHNiInuVlgJ:blog.csdn.net/baoqiangwang/archive/2009/10/22/4712461.aspx+oracle%E5%88%86%E6%9E%90%E5%87%BD%E6%95%B0+%E7%B4%AF%E8%AE%A1&cd=3&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy29N6zIg3PpMQ30XKkkcwLGxpcIdqg[@more@]
select region_id,
2 customer_id,
3 ntile(5) over(order by sum(customer_sales) desc) til
4 from user_order
5 group by region_id, customer_id;
REGION_ID CUSTOMER_ID TILE
本文来自: () 详细出处参考：http:///html/article/database/oracle/20081216/14775_4.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/450962/viewspace-1028972/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
