【正文】
sum(qty)from spjgroup by sno實驗結(jié)果截圖:(4) sql語句如下:update pset color=39。where pno=39。 or city like 39。 and jno=(select jno from j where jname like 39。where color=39。where sno=39。 and pno=39。select * from s實驗結(jié)果截圖:(12) sql語句如下:deletefrom spjwhere pno in(select pno from p where pname like 39。select * from p實驗結(jié)果截圖:(13) sql語句如下:deletefrom spjwhere (sno=39。) and jno in (select jno from j where jname=39。 or pname=39