I am trying to get top 20 servers where the servername Count is maximum.
Here is my Query ...
Select Count(Server_Name)ServerCount , Server_Name from Temp1 A
Group By Server_Name
Having COUNT(Server_Name) = (Select MAX(CNT) from (Select Count(Server_Name)as CNT , Server_Name from Temp1 group By Server_Name )A
I can get only one server name which has the maximum # of servers.
I tried top 20 but its not working .. Any ideas?
The Table has this Column called Server Name such as
So , I need to get the servername Counts which repeat multiple times and get the max of those for top 20.
(Hope I haven't made it confusing)