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 3
Weather Observation Station 3
Sort by
recency
|
1967 Discussions
|
Please Login in order to post a comment
this is working : SELECT DISTINCT CITY FROM STATION WHERE MOD(ID,2) = 0 ORDER BY CITY;
this is not working :
SELECT DISTINCT city FROM station WHERE id % 2 = 0;
For MySQL
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0
SELECT CITY FROM STATION WHERE ID % 2 = 0 GROUP BY CITY
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;