find a number of something in sql code example Example: find number of entries sql Select count(CITY) - count(DISTINCT CITY) from tablename