select field1,field1/sum(field1) over() a from table1; 转载于:https://www.cnblogs.com/chen1388/archive/2010/08/12/1798434.html