Weather Observation Station 4

Sort by

recency

|

1426 Discussions

|

  • + 0 comments

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

  • + 0 comments

    SELECT COUNT(CITY)- COUNT(DISTINCT CITY) FROM STATION;

  • + 0 comments

    Select Count(*) - Count(Distinct City) From Station;

  • + 0 comments

    SELECT COUNT(*) - COUNT(DISTINCT [CITY]) FROM STATION;

  • + 0 comments

    In this, we will count the number of CITY and number of DISTINCT CITY and then substract it.

    SELECT count(city) - count(DISTINCT city) FROM station;