Weather Observation Station 4

Sort by

recency

|

1441 Discussions

|

  • + 0 comments

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

  • + 1 comment

    TYPE1: Select Count(City) - Count(Distinct City) From Station; TYPE2: Select Count(*) - Count(Distinct City) From Station;

  • + 0 comments

    There are two way to solve that problem;

    1. SELECT COUNT(city)-COUNT(DISTINCT(city) FROM Station;

    2. SELECT COUNT(city)-COUNT(DISTINCT(city) AS Difference FROM Station;

  • + 0 comments

    select (select count(CITY) from STATION)-(select count(distinct city) from station);

  • + 0 comments

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