find number of entries sql code example

Example: find number of entries sql

Select  count(CITY) - count(DISTINCT CITY) 
from tablename