Oracle分析函数详

http://www.91linux.com/html/article/database/oracle/20081216/14775_4.html

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

本文来自: (www.91linux.com) 详细出处参考：http://www.91linux.com/html/article/database/oracle/20081216/14775_4.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/450962/viewspace-1028972/，如需转载，请注明出处，否则将追究法律责任。