count number of entries sql code example

Example 1: sql query to get the number of rows in a table

SELECT COUNT(*) FROM tablename

Example 2: find number of entries sql

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