You are viewing a single comment's thread. Return to all comments →
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;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 3
You are viewing a single comment's thread. Return to all comments →
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;