sql find difference between two sql count code example Example: count in sql and diff select (count(city)-count(distinct city)) from station;