Count the number of occurrences of a field in a table from the database

A recent new requirement is to find out how many times a field has been repeated in a data table to rank it, so the question is, how does SQL write it?

Since the count must be counted, the last SQL you get is

SELECT TOP field1,field1count = COUNT (field1) from table1 GROUP by Field1 ORDER by Field1count DESC

This SQL means to count the number of field1 field flushes from table1 and select the Top 100 field1

A good memory is worse than a bad pen!

Count the number of occurrences of a field in a table from the database