SUBTRACT DESTINCT COUNT FROM SQL COUNT code example Example: get substract count sql select Count(City) - Count(Distinct(City)) from Station;