We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 4
Weather Observation Station 4
Sort by
recency
|
1443 Discussions
|
Please Login in order to post a comment
SELECT COUNT(city) - COUNT(DISTINCT CITY) FROM station;
SELECT COUNT(*) - COUNT(DISTINCT CITY) AS difference FROM STATION;
SELECT COUNT(CITY)- COUNT(DISTINCT CITY) FROM STATION AS DIFFERENCE ;
TYPE1: Select Count(City) - Count(Distinct City) From Station; TYPE2: Select Count(*) - Count(Distinct City) From Station;
Select Count(City) - Count(Distinct City) Why it is giving error Select Count(City) , Count(Distinct City For this
There are two way to solve that problem;
SELECT COUNT(city)-COUNT(DISTINCT(city) FROM Station;
SELECT COUNT(city)-COUNT(DISTINCT(city) AS Difference FROM Station;