Oracle高级查询之OVER (PARTITION BY ..)等等
http://blog.csdn.net/ayou2008/article/details/7179001