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

  • 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