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
  • Apply
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Basic Select
  4. Japanese Cities' Names
  5. Discussions

Japanese Cities' Names

Problem
Submissions
Leaderboard
Discussions

Sort 290 Discussions, By:

recency

Please Login in order to post a comment

  • apurwasinha37
    7 days ago+ 0 comments
    SELECT name
    FROM city
    WHERE
        countrycode="JPN";
    
    0|
    Permalink
  • souhardyaray252
    2 weeks ago+ 0 comments

    select name from city where countrycode='JPN';

    0|
    Permalink
  • ashish98875
    4 weeks ago+ 0 comments
    select name from city where countrycode = 'JPN';
    
    0|
    Permalink
  • amaanfarooqui721
    1 month ago+ 1 comment

    select NAME from CITY where COUNTRYCODE = "JPN";

    Make sure you have selected MySQL not DB2

    0|
    Permalink
  • Dabhivaidehi2206
    1 month ago+ 0 comments

    SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

    0|
    Permalink
Load more conversations

Need Help?


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