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 52 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.

  • 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'

  • zaynabmedia + 0 comments

    select * from city where countrycode='JPN'

  • deepaktiwari0821 + 0 comments

    select * from city where countrycode='JPN';

  • coder_aky + 0 comments

    100% Working Simple and easy :-)

    SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';
Load more conversations