这句sql哪错了？

[zxzy1981]

SELECT DISTINCTROW TagName,Value,Time AS [Time of Min]
FROM Tag0101
WHERE Value=Min(Tag0101.Value)
GROUP BY Tag0101.TagName;


表如下：
tagname value time
a 5 0:00
b 10 1:00
b 12 2:00
a 3 3:00

该查询是想按tagname分组显示最小值出现时间，如下：
tagname value time
a 5 0:00
b 12 2:00

-------------------------
系统说是where子句中不能有合计函数，那么应该怎么改啊?

[cheny1234]

SELECT DISTINCTROW TagName,Min(Value),Time AS [Time of Min]
FROM Tag0101

[cheny1234]

SELECT DISTINCTROW TagName,Min(Value),Time AS [Time of Min]
FROM Tag0101 GROUP BY TagName

[zxzy1981]

这中方法有局限性啊，假如还要统计最大值出现时间呢，比如:
tagname max maxtime min mintime
a 5 0:00 3 3:00
b 12 2:00 10 1:00

[cheny1234]

select a.tagname,a.[max],a.[maxtime],b.[min],b.[mintime]
(SELECT TagName,Max(Value) as [max],Time AS [maxtime]
FROM Tag0101 GROUP BY TagName) a ,
(SELECT TagName,Min(Value) as [min],Time AS [mintime]
FROM Tag0101 GROUP BY TagName) b
where a.tagname=b.tagname

[cheny1234]

不对的。

select a.tagname,a.[max],a.[maxtime],b.[min],b.[mintime]
(select a1.*,a2.time as [maxtime] from
(SELECT TagName,Max(Value) as [max]
FROM Tag0101 GROUP BY TagName) a1,tag0101 a2
where a1.tagname=a2.tagname and a1.[max]=a2.[value]
) a ,
(select b1.*,b2.time as [mintime] from
(SELECT TagName,Min(Value) as [min]
FROM Tag0101 GROUP BY TagName) b1,tag0101 b2
where b1.tagname=b2.tagname and b1.[max]=b2.[value]
) b,
where a.tagname=b.tagname

[jianxin_js]

学习