非聚合函数的列必须出现在group by 中:
SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource GROUP BY DutyName,PhaseName,VersionID
SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource GROUP BY DutyName,PhaseName,VersionID
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName,VersionID --少写了一个字段
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName
那么在select中出现的字段,要么放在聚合函数中,要么放在group by中
SELECT DutyName,PhaseName,VersionID
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName,VersionID
或SELECT DutyName,PhaseName,MAX(VersionID) AS VersionID
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName
或
SELECT DutyName,PhaseName,Min(VersionID) AS VersionID --可根據需求是其他聚合函数
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName
SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName,VersionID