I have a table with the columns 

FacilityID, servername

with the facilityID being the primary key and the servername being the server that the data for that facility is located on. 

When we add a new facility, I want to be able to select the servername used the least number of times, but I am not sure how to do that.

I am thinking it will use the count function, but I am unsure of the syntax involved.

Any help will be appreciated.