Weather Observation Station 3

  • + 0 comments

    SOLUCTION OF MYSQL :

    SELECT DISTINCT CITY

    FROM STATION

    WHERE MOD(ID, 2) = 0

    DISTINCT -- SERVE PARA DIFERENCIAR VALORES DUPLICADOS E IMPRIMIR SOMENTE UM EXEMPLO:

    SELECT CITY, ID FROM COUNTRYS // OUTPOT : 01 LONDON , 01 LONDON

    SELECT DISTINCT CITY , ID FROM COUNTRYS OUTPUT/: 01. LONDON