Weather Observation Station 3

Sort by

recency

|

1979 Discussions

|

  • + 0 comments

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

  • + 0 comments

    select distinct city from station where RIGHT(DIGITS(id), 1) in ('0', '2', '4', '6', '8');

  • + 1 comment

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

  • + 0 comments

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

  • + 0 comments

    you need to know that for duplicant we need to use distinct clause answer for this is select distinct city from station where id % 2 = 0;