t-sql count of subquery code example Example: get substract count sql select Count(City) - Count(Distinct(City)) from Station;