MySQL如何计算STUDENT表三科总分并筛选总分大于75的学生

实现SQL语句 #

你可以直接对三个科目分数字段求和得到总分，再通过条件筛选即可，MySQL支持直接在HAVING子句中引用SELECT中定义的别名，写法更简洁：

SELECT 
  roll_number,
  name,
  subject_one + subject_two + subject_three AS total
FROM STUDENT
HAVING total > 75;

如果你需要兼容标准SQL语法，也可以把求和逻辑写在WHERE条件中：

SELECT 
  roll_number,
  name,
  subject_one + subject_two + subject_three AS total
FROM STUDENT
WHERE subject_one + subject_two + subject_three > 75;

执行结果 #

两种写法都会返回符合要求的2条数据：

内容的提问来源于stack exchange，提问作者Jay Yadav