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)谁能帮我简化一下!
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 Id,sum(...) from table where ...... group by Id having min(sum(...)) having 中所有的聚集函数都可用! 在我的使用中发现只要有group by 而无 union 时,无需使用 order by 可按 Id 升序排列!
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)谁能帮我简化一下!
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)
from table
where ......
group by Id
having min(sum(...))
having 中所有的聚集函数都可用!
在我的使用中发现只要有group by 而无 union 时,无需使用 order by 可按 Id 升序排列!