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
  • Prepare
    NEW
  • Certify
  • Compete
  • Career Fair
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 3
  5. Discussions

Weather Observation Station 3

Problem
Submissions
Leaderboard
Discussions

    You are viewing a single comment's thread. Return to all comments →

  • smaniraj15
    4 years ago+ 21 comments
        for ORACLE   =>    SELECT DISTINCT(CITY) FROM STATION WHERE MOD(ID,2)=0 ; 
    
    
    for MySQL   =>    SELECT DISTINCT(CITY) FROM STATION WHERE (ID%2)=0 ;
    
    151|
    Permalink
  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy
  • Request a Feature