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
|
1361 Discussions
|
Please Login in order to post a comment
Select count(CITY) - count(Distinct(CITY)) FROM STATION
In MySQL, you should avoid spaces between the function name and the parentheses. For example, instead of COUNT (), you should write COUNT().
Select count(City) - count(Distinct(City)) from Station;
SELECT (COUNT(*) - COUNT(DISTINCT CITY)) AS difference FROM STATION;
For MySQL