作业帮sql语句：去掉最大值,去掉最小值,算平均值SELECT AVG(Scores.Score)FROM ScoresWHERE ( ( (Scores.[ID]) = @id)AND (Score < (SELECT MAX(Score) From Scores WHERE Scores.[ID] = @id) )AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[I
来源：学生作业帮助网 编辑：作业帮 时间：2024/04/28 16:12:12
![sql语句：去掉最大值,去掉最小值,算平均值SELECT AVG(Scores.Score)FROM ScoresWHERE ( ( (Scores.[ID]) = @id)AND (Score < (SELECT MAX(Score) From Scores WHERE Scores.[ID] = @id) )AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[I](/uploads/image/z/3688866-18-6.jpg?t=sql%E8%AF%AD%E5%8F%A5%EF%BC%9A%E5%8E%BB%E6%8E%89%E6%9C%80%E5%A4%A7%E5%80%BC%2C%E5%8E%BB%E6%8E%89%E6%9C%80%E5%B0%8F%E5%80%BC%2C%E7%AE%97%E5%B9%B3%E5%9D%87%E5%80%BCSELECT+AVG%28Scores.Score%29FROM+ScoresWHERE+%28+%28+%28Scores.%5BID%5D%29+%3D+%40id%29AND+%28Score+%3C+%28SELECT+MAX%28Score%29+From+Scores+WHERE+Scores.%5BID%5D+%3D+%40id%29+%29AND+%28Score+%3E+%28SELECT+MIN%28Score%29+From+Scores+WHERE+Scores.%5BI)
sql语句：去掉最大值,去掉最小值,算平均值SELECT AVG(Scores.Score)FROM ScoresWHERE ( ( (Scores.[ID]) = @id)AND (Score < (SELECT MAX(Score) From Scores WHERE Scores.[ID] = @id) )AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[I
sql语句：去掉最大值,去掉最小值,算平均值
SELECT AVG(Scores.Score)
FROM Scores
WHERE ( ( (Scores.[ID]) = @id)
AND (Score < (SELECT MAX(Score) From Scores WHERE Scores.[ID] = @id) )
AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[ID] = @id) ) )
如果出现相同的分数则计算结果会不对.会少一些分数
我并不是想去除重复分数,而是比如
100 20 30 40 40 60 100
我希望：AVG（30+40+40+60+100）
做高分有重复的话,只删除一个
sql语句：去掉最大值,去掉最小值,算平均值SELECT AVG(Scores.Score)FROM ScoresWHERE ( ( (Scores.[ID]) = @id)AND (Score < (SELECT MAX(Score) From Scores WHERE Scores.[ID] = @id) )AND (Score > (SELECT MIN(Score) From Scores WHERE Scores.[I
SELECT (sum(Scores.Score)-max(Scores.Score)-min(Scores.Score))/（count(*)-2）
FROM Scores
WHERE (Scores.[ID]) = @id group by (Scores.[ID])
Oracle下可以的,你用的是什么数据库.