SELECT (sum(Scores.Score)-max(Scores.Score)-min(Scores.Score))/(count(*)-2)
FROM Scores
WHERE (Scores.[ID]) = @id group by (Scores.[ID])
Oracle下可以的,你用的是什么数据库.
SELECT (sum(Scores.Score)-max(Scores.Score)-min(Scores.Score))/(count(*)-2)
FROM Scores
WHERE (Scores.[ID]) = @id group by (Scores.[ID])
Oracle下可以的,你用的是什么数据库.