sql-server - Flag/Mark 最高排名记录

Question

我有一个最终看起来像这样的查询:

DECLARE @Rank TABLE
(
     Team VARCHAR(3),
     StatCount TINYINT,
     TeamRank TINYINT
)
INSERT INTO @Rank VALUES ('AAA', 10, 5)
INSERT INTO @Rank VALUES ('AAA', 7, 4)
INSERT INTO @Rank VALUES ('AAA', 6, 3)
INSERT INTO @Rank VALUES ('AAA', 4, 2)
INSERT INTO @Rank VALUES ('AAA', 2, 1)

SELECT * From @Rank ORDER BY TeamRank DESC

现在我的需求是标记最高排名，以便前端可以突出显示该记录。我对其他想法持开放态度，但一开始就尝试了这个，但它的表现并不像预期的那样。因此，如果您能指出我做错了什么或以其他方式提到，我将不胜感激。

SELECT 
    Team,
    StatCount,
    TeamRank,
    (
        CASE 
            WHEN MAX(StatCount) = StatCount
                THEN 'True'
            ELSE
                'False'
            END
    ) AS 'HighScore'
FROM Rank
ORDER BY Team DESC;

谢谢

MY Mistake!

DDL 的每个条目都有“AAA”，但它们是不同的。应该是'AAA','BBB','CCC'等。

Thank You everyone for your answers. I apologize again for the bad DDL data.

Answer 1

尝试

SELECT 
    Team,
    StatCount,
    TeamRank,
    (
        CASE 
            WHEN StatCount = (select max(StatCount) from @Rank)
                THEN 'True'
            ELSE
                'False'
            END
    ) AS 'HighScore'
FROM @Rank
ORDER BY Team DESC