mysql - Find SQL statement
黄舟
黄舟 2017-05-18 10:50:09
0
2
771


How to use SQL statements to realize the sum of each column in Total One, Total Two, and Total Three?

黄舟
黄舟

人生最曼妙的风景,竟是内心的淡定与从容!

reply all(2)
巴扎黑
select sum(num) from table group by title;
洪涛

Are total one, total two and total three the column names of three columns? Do you want to calculate the sum of these three columns respectively?
If that’s what you mean, then try
select sum(合计一) from 表名;
Calculate the sum of one column in this way, and the other two are the same

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template