Weather Observation Station 3

Sort by

recency

|

1948 Discussions

|

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

    group by can be also used

    select CITY FROM STATION WHERE ID % 2 = 0 group by CITY;

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE ID %2=0 AND LAT_N >0 AND LONG_W >0 ;

  • + 0 comments

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

  • + 0 comments

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