• Add WITH TIES to your select top 20. Hope the following helps illustrate what you need:

    create table dbo.production(

    ServerName varchar(20),

    ServerState varchar(10)

    );

    insert into dbo.production

    values ('ABC','A'),('ABC','B'),('ABC','C'),('ABC','D'),('ABC','E'),

    ('CDE','A'),('CDE','B'),('CDE','C'),('CDE','D'),('CDE','E'),

    ('FGH','A'),('FGH','B'),('FGH','C'),('FGH','D'),

    ('ZXC','A'),('ZXC','B'),('ZXC','C'),('ZXC','D'),('ZXC','E')

    Select top 1 with ties COUNT(ServerState) StateCount ,ServerName

    FROM production

    Group By ServerName

    Order By COUNT(ServerState ) Desc;

    drop table dbo.production;

    Please note that I was running this in a sandbox database and clean up after using the table.