query to find the number of SQL documents in a table code example

Example: find number of entries sql

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