SQL Server:获取和求和最小值

我会用一个子查询。这将得到您要查找的16个答案:

    SELECT   SUM (min_by_store)
    FROM     (SELECT     Store, min(on_hand) AS min_by_store
                FROM     #Temp AS T
            GROUP BY     Store) AS MBS

select sum(on_hand)
from t
where t.sku = (select top (1) t2.sku
               from t t2
               where t2.store = t.store
               order by t2.on_hand
              );