求个ORACLE关于SQL的统计语句
ID BATCHCODE PARTNUMBER DB_COUNT IS_REPLACE REPLACE_PARTNUMBER
1 Y001 1015331002010801500022 5 0 NULL
2 Y001 1015331002010801500023 6 1 1015331002010801500022
3 Y002 1015331002010801500024 5 0 NULL
4 Y003 1015331002010801500026 6 1 1015331002010801500025
怎么得到主料的调拨数据。
结果为:
ID BATCHCODE PARTNUMBER DB_COUNT IS_REPLACE REPLACE_PARTNUMBER
1 Y001 1015331002010801500022 11 0 NULL
3 Y002 1015331002010801500024 5 0 NULL
4 Y003 10153310020108015000
25 6 0 NULL
select min(id) ID,
BATCHCODE,
min(PARTNUMBER) PARTNUMBER,
sum(DB_COUNT) DB_COUNT,
0 IS_REPLACE,
null REPLACE_PARTNUMBER
from 表
group by BATCHCODE