要使用MySQL查询选择多个总和列并将它们显示在单独的列中,您需要使用CASE语句。语法如下:SELECT
SUM( CASE WHEN yourColumnName1=’yourValue1’ THEN yourColumnName2 END ) AS yourSeparateColumnName1,
SUM( CASE WHEN yourColumnName1=’yourValue2’ THEN yourColumnName2 END ) AS yourSeparateColumnName2,
SUM( CASE WHEN yourColumnName1=’yourValue3’ THEN yourColumnName2 END ) AS yourSeparateColumnName3,
.
.
.
N
FROM yourTableName;
为了理解上述语法,让我们创建一个表。创建表的查询如下:mysql> create table selectMultipleSumDemo
-> (
-> Id int NOT NULL AUTO_INCREMENT,
-> PlayerName varchar(20),
-> PlayerScore int,
-> PRIMARY KEY(Id)
-> );
现在,您可以使用insert命令在表中插入一些记录。查询如下:mysql> insert into selectMultipleSumDemo(PlayerName,PlayerScore) values('Maxwell',89);
mysql> insert into selectMultipleSumDemo(Play