SQL优化之over的使用

select t.grade, t.losal from salgrade t

[img]http://dl2.iteye.com/upload/attachment/0088/7606/5a51a40f-090a-3715-b657-790a1337e912.png[/img]

select t1.grade, t1.losal, sum(t2.losal)
  from salgrade t1
  join salgrade t2
    on t2.grade <= t1.grade
 group by t1.grade, t1.losal
 order by 1, 2

[img]http://dl2.iteye.com/upload/attachment/0088/7608/f16e9588-5697-3f8c-9aa9-533a490f2303.png[/img]

select grade, losal, sum(losal) over(order by grade) from salgrade

[img]http://dl2.iteye.com/upload/attachment/0088/7610/efc0a86f-1f85-3732-b870-18a11d3a7bb5.png[/img]

打开oracle执行计划简单示例[img]http://dl2.iteye.com/upload/attachment/0090/2183/deadffd3-9faa-3dbf-b3da-d630ca989c42.png[/img]
或
[img]http://dl2.iteye.com/upload/attachment/0088/8721/5e238302-c92f-3c0d-a181-732c8cf65184.png[/img]
[url=http://www.cnblogs.com/umen/archive/2011/04/11/2012136.html]Oracle over函数[/url]

[url=http://blog.csdn.net/zhang_chuancun/article/details/6530934]oracle 递归 level[/url]

[url=http://www.cnblogs.com/wuyisky/archive/2010/02/24/oracle_rank.html]oracle分析函数Rank, Dense_rank, row_number[/url]

[url=http://www.cnblogs.com/wuyisky/archive/2010/02/24/oracle_over.html]oracle 分析函数over[/url]

[url=http://borglee.iteye.com/blog/1100548]MySQL实现Oracle里的 rank()over(ORDER BY) 功能[/url]

[url=http://hudingchen.iteye.com/blog/1551422]一个SQL的优化[/url]

oracle多线程删除数据

delete    /*+parellel(t,2)*/  from  t_unicom_ebill t where t.id='test'

[url=http://www.cnblogs.com/rollenholt/p/3691594.html]提高SQL的查询效率[/url]