select Id,sum(...)
from table
where ......
group by Id
having min(sum(...))
having 中所有的聚集函数都可用!
在我的使用中发现只要有group by 而无 union 时,无需使用 order by 可按 Id 升序排列!
select TeamID,[sum]
from
(select TeamID,sum(score) as [sum] from Test group by TeamID)as B
where [sum] in
(select min([sum])
from
(select TeamID,sum(score) as [sum] from Test group by TeamID)as B)
select TeamID,[sum]
from
(select TeamID,sum(score) as [sum] from TableA group by TeamID)as B
where [sum] in
(select min([sum])
from
(select TeamID,sum(score) as [sum] from TableA group by TeamID)as B)