Weather Observation Station 3

Sort by

recency

|

1953 Discussions

|

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID%2 = 0;

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE MOD(ID, 2) = 0;

  • + 0 comments

    remove comment /* and */ , use the below sql select DISTINCT CITY FROM STATION where ID%2 = 0;

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID IN (SELECT ID FROM STATION WHERE ID % 2 = 0 )

  • + 0 comments

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