使用相关子查询：

select t.*
from t
where t.usage = (select max(t2.usage) from t t2 where t2.name = t.name);

我只想用max和group by组合

SELECT Name, Max([Speed Tier]), Max(Usage)
FROM TableName
GROUP BY Name
ORDER BY Name

或者如果你只想要一个价值最高的人

SELECT TOP 1 Name, [Speed Tier], Usage
FROM TableName
GROUP BY Name
ORDER BY [Usage] desc

或者如果你想要最高的使用率和当前行的速度

;with CTE as (SELECT TOP 1 Name, Max(Usage) as Usage
FROM @mytable
GROUP BY Name
Order by Usage desc
)
select 
    T.name, T.[Speed Tier], T.usage
from cte as C
inner join @mytable as T on T.Name = C.name and T.usage = C.Usage

我会坚持到底 MAX 以及 GROUP :

SELECT Name, Max(Usage)
FROM YourTableName
GROUP BY Name

SELECT TOP 1 Name
    ,Usage
FROM your TABLE
ORDER BY Usage DESC -- if you want the highest

SELECT TOP X Name
    ,Usage
FROM your TABLE
ORDER BY Usage DESC -- if you want to select the top X rows

SELECT Name
    ,MAX(Usage) Usage 
FROM your TABLE
GROUP BY Name -- if you want to know each Name's highest usage