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