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.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Japanese Cities' Attributes
  5. Discussions

Japanese Cities' Attributes

Sort 55 Discussions, By:

votes

  • ldai100 + 1 comment

    isn't this a repeat of the previous challenge?

    • shivashettyswat2 + 0 comments

      select * from city where COUNTRYCODE='JPN';

  • marinskiy + 1 comment

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';

    Feel free to ask if you have any questions :)

    • margeromeabana + 2 comments

      That's my answer, but it keeps giving me "wrong answer"

      I dont why.

      • marinskiy + 1 comment

        Try to check if you selected "Oracle" here:

        • mkomatineni95 + 0 comments

          TRY THIS CODE

          SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN'; It actually works

      • ccasbre27 + 0 comments

        if you are using Oracle you must add a semicolon at the end of the instruction

  • yosefvb + 0 comments
    SELECT * FROM CITY
WHERE COUNTRYCODE = 'JPN';

    Remember to use single quotes here. It is best practice to use single quotes ('JPN') in SQL, even though double quotes ("JPN") will work in MySQL.

  • ganesh_tumkur23 + 0 comments

    jpn wont work, JPN(caps) will work

  • akag0284 + 0 comments

    when i am trying

    select * from city WHERE countrycode = 'jpn';

    it goes to wrong answer what should i do??

  • naik2191 + 0 comments

    MySQL : 

    SELECT * 
FROM CITY 
WHERE 
    COUNTRYCODE = 'JPN'

  • zerotohero + 0 comments
    -- mysql
SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN'

  • kbmanojkumar_201 + 0 comments

    SELECT * FROM city WHERE countrycode='JPN';

  • al1609073 + 0 comments

    My solution: SELECT *FROM CITY WHERE COUNTRYCODE = 'JPN';

  • Kesharwani_supr1 + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE='JPN'

Load more conversations