Question

pl/sql对表中相同字段求和，并把和放到后面一列

本来的数据如图1，想要实现的是图2，求大神解答
用sql语句怎么写





Answer 1

pl/sql对表中相同字段求和，并把和放到后面一列
<a href="https://www.baidu.com/s?wd=select&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBPjT4P1mvPynsnWwhrjR40ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnH64PjRsn104PW63rHDsrjnsn0" target="_blank" class="baidu-highlight">select</a> <a href="https://www.baidu.com/s?wd=left&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBPjT4P1mvPynsnWwhrjR40ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnH64PjRsn104PW63rHDsrjnsn0" target="_blank"class="baidu-highlight">left</a>(字段1,2),<a href="https://www.baidu.com/s?wd=sum&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBPjT4P1mvPynsnWwhrjR40ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnH64PjRsn104PW63rHDsrjnsn0" target="_blank" class="baidu-highlight">sum</a>(字段2) from 表名 group <a href="https://www.baidu.com/s?wd=by&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBPjT4P1mvPynsnWwhrjR40ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnH64PjRsn104PW63rHDsrjnsn0" target="_blank" class="baidu-highlight">by</a> <a href="https://www.baidu.com/s?wd=left&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1dBPjT4P1mvPynsnWwhrjR40ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnH64PjRsn104PW63rHDsrjnsn0" target="_blank" class="baidu-highlight">left</a>(字段1,2)