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
|
1317 Discussions
|
Please Login in order to post a comment
SELECT COUNT(CITY)-COUNT(DISTINCT CITY )AS DIFFERENCE FROM STATION;
SELECT COUNT(CITY)-COUNT(DISTINCT CITY) AS DIFFRENCE FROM STATION;
SELECT COUNT(CITY)-COUNT(DISTINCT CITY) AS DIFERENCA FROM STATION;
SELECT (COUNT(CITY) - COUNT(DISTINCT(CITY))) AS difference FROM STATION; Works fine :)
this one working select count(city) - count(distinct (city)) from station