Everyone, please. I have an urgent question!

clarkmaaa · Post time: 2020-1-20 21:40:02

wlbh wlmc sl cz jbh
D71-AA AD 42 DD D71
D71-AA DS 31 DD D71
D71-AA GG 76 DD D71
I want to add the SL (mathematics) of the same WLBH, what should this table do?

fanfan1980 · Post time: 2020-1-30 09:27:01

select wlbh, sl = sum (sl) from tbName group by wlbh

我是杀人狂 · Post time: 2020-1-30 10:18:01

select wlbh, sum (sl) as sl, cz, jbh from tablename group by wlbh

imapiggy · Post time: 2020-1-30 23:45:01

Upstairs are all right!

		Remember me	Forgot password?
Password			Register