Weather Observation Station 4

Sort by

recency

|

1443 Discussions

|

  • + 0 comments

    SELECT COUNT(city) - COUNT(DISTINCT CITY) FROM station;

  • + 0 comments

    SELECT COUNT(*) - COUNT(DISTINCT CITY) AS difference FROM STATION;

  • + 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

      Select Count(City) - Count(Distinct City) Why it is giving error Select Count(City) , Count(Distinct City For this

  • + 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;