GROUP BY 的问题

[fjliningcd]

SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource GROUP BY DutyName,PhaseName

[fjliningcd]

错在哪

[zheninchangjiang]

非聚合函数的列必须出现在group by 中:
SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource GROUP BY DutyName,PhaseName,VersionID

[zjcxc]

SELECT DutyName,PhaseName,VersionID
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName,VersionID --少写了一个字段

[zjcxc]

SELECT DutyName,PhaseName,min(VersionID) --或者将它放在聚合函数中
FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName

[zjcxc]

--这是SQL的规定,如果使用了group by
那么在select中出现的字段,要么放在聚合函数中,要么放在group by中

[progress99]

如果字段沒在聚合函数中，再一定要在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

[shuichangliu]

SELECT DutyName,PhaseName,VersionID FROM T_TaskEffectSource
GROUP BY DutyName,PhaseName,VersionID