oracle 函数：over

没有时间写了，转几个链接吧

http://www.blogjava.net/pengpenglin/archive/2008/06/25/210536.html

http://blog.csdn.net/inthirties/article/details/4673331

 

顺便记一下with as

http://blog.csdn.net/a9529lty/article/details/4923957