Sql count

Question

How can i select the differences between occurance of rows in a table and the occurance of a distinct rows in a table.
Heres what i have tried..

select count(city) from station-select count(distinct city) from station

Answer 1

Select count(field) - count(distinct field) as diff will work on most databases.

Answer 2

Ipang Sandra Meyer thank you guyz

Answer 3

Ipang no it didnt work

Answer 4

Ipang i want to see the number of the records based on their cities (can contain duplicates) - no of records with no duplicate city name

Answer 5

Sandra Meyer thank you it works