We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 3
  5. Discussions

Weather Observation Station 3

Sort by

recency

|

1912 Discussions

|

  • sagar_agrawal9t2
     + 0 comments

    SELECT DISTINCT CITY from STATION where (ID % 2 = 0) ORDER BY CITY;

  • manishsarmaa
     + 0 comments

    SOLUTION FOR MYSQL

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

  • ericviniciusw071
     + 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

  • saipavanreddysa1
     + 1 comment

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

  • ayushkumar111528
     + 0 comments

    SELECT distinct city FROM station where id % 2 = 0;