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.
  • HackerRank Home

    HackerRank

  • |
  • Prepare
  • Certify
  • Compete
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 3
  5. Discussions

Weather Observation Station 3

Problem
Submissions
Leaderboard
Discussions

Sort 1503 Discussions, By:

recency

Please Login in order to post a comment

  • fawadalikhan
    2 days ago+ 0 comments

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

    For Oracle

    For Confirmation that result is Correct, we can check the ID's , that these are EVEN.

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

    0|
    Permalink
  • nbkrank
    5 days ago+ 0 comments

    Solution in video https://www.youtube.com/watch?v=Dyud5fwMUX0

    0|
    Permalink
  • manivarshithkud1
    1 week ago+ 0 comments

    Select DISTINCT CITY from STATION where ID%2=0

    0|
    Permalink
  • nghiapq21
    1 week ago+ 0 comments
    SELECT DISTINCT CITY
    FROM STATION
    WHERE MOD(ID, 2) = 0;
    
    0|
    Permalink
  • maheshkanekal761
    1 week ago+ 0 comments

    for my sql where id % 2=0; for oracle mod(id,2) =0;

    0|
    Permalink
Load more conversations

Need Help?


View top submissions
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy