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