复制代码 代码如下:-- 创建库
CREATE TABLE `rate` ( `uname` VARCHAR (300), `object` VARCHAR (300), `score` VARCHAR (300));
-- 插⼊数据
INSERT INTO test.rate (uname, object, score) VALUES('aaa', 'chinese', '67'), ('aaa', 'math', ''), ('aaa', 'physical', ''), ('bbb', 'chinese', '67'), ('bbb', 'math', '75'), ('bbb', 'physical', '');
-- 查询
SELECT DISTINCT uname AS '姓名',SUM(CASE object
WHEN 'chinese' THEN score END) AS '语⽂',SUM(CASE object
WHEN 'math' THEN score END) AS '数学',SUM(CASE object
WHEN 'physical' THEN score END) AS '物理' FROM rate GROUP BY uname;
因篇幅问题不能全部显示，请点此查看更多更全内容
Copyright © 2019- huatuoyibo.cn 版权所有 湘ICP备2023022426号-1
违法及侵权请联系：TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务