问题一: select sum(decode(column,1,column,0)) from table group by column;问题二: select sum(decode((sing(10-column)+sign(column-1))*sign(column-3),-2,column,2,column,0)) from table group by column;
2.如果是8.1.6以上的可以用case select sum(case when column>10 and column<1 and column<>3 then sal else 0 end) from table
select sum(decode(column,1,column,0)) from table group by column;问题二:
select sum(decode((sing(10-column)+sign(column-1))*sign(column-3),-2,column,2,column,0)) from table group by column;
select sum(case when column>10 and column<1 and column<>3 then sal else 0 end) from table