Weather Observation Station 3

Sort by

recency

|

1967 Discussions

|

  • + 0 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;

  • + 0 comments

    For MySQL

    SELECT DISTINCT city FROM station
    WHERE id % 2 = 0;
    
  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0

  • + 0 comments

    SELECT CITY FROM STATION WHERE ID % 2 = 0 GROUP BY CITY

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;