SELECT SUM(SL1)
FROM TABLENAME
WHERE MC IN ('A', 'B', 'C', 'D', 'E', 'F')UPDATE TABLENAME
SET SL2 = (
SELECT SUM(SL1)
FROM TABLENAME
WHERE MC IN ('B', 'C', 'D', 'E', 'F'))
WHERE MC = 'A'
FROM TABLENAME
WHERE MC IN ('A', 'B', 'C', 'D', 'E', 'F')UPDATE TABLENAME
SET SL2 = (
SELECT SUM(SL1)
FROM TABLENAME
WHERE MC IN ('B', 'C', 'D', 'E', 'F'))
WHERE MC = 'A'
>>select sum(SL1) from table where MC in (A,B,C,D,E,F)
2、
如何将B、C、D、E、F的SL1的和赋值给A的SL2????
>>Update table set SL2 = (select sum(SL1) from table where MC in(B,C,D,E,F))
where MC = A
先谢谢!!!