sql將兩列連接成一列 怎么把兩列的數(shù)據(jù)求和(先每列求和,再把結(jié)果再相加)sql數(shù)據(jù)庫(kù)?
怎么把兩列的數(shù)據(jù)求和(先每列求和,再把結(jié)果再相加)sql數(shù)據(jù)庫(kù)?從Biao中選擇sum(Shuliang)*4,sum(wancansl)*4,(sum(Shuliang)*4,sum(wancans
怎么把兩列的數(shù)據(jù)求和(先每列求和,再把結(jié)果再相加)sql數(shù)據(jù)庫(kù)?
從Biao中選擇sum(Shuliang)*4,sum(wancansl)*4,(sum(Shuliang)*4,sum(wancansl)*4)
使用groupby的功能就是分組匯總。選擇列1,sum(列2)txfrom table group by column 1