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
|
1973 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT CITY FROM STATION WHERE ID%2=0 ORDER BY CITY;
SELECT DISTINCT city FROM station WHERE RIGHT(id,1) not in (1,3,5,7,9)
SELECT CITY FROM STATION WHERE ID%2=0 GROUP BY CITY;
SELECT DISTINCT CITY FROM STATION WHERE ID%2=0;
Test cases here are for the DISTINCT keyword only and not ORDER BY
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;