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

  • naveenvelu0741 + 0 comments

    SELECT NAME FROM CITY WHERE COUNTRYCODE= 'JPN

    THIS CODE IS NOT CORRECT EXECUTE

  • rohitharavadasa1 + 0 comments

    select * from city where countrycode='JPN';

  • prasanth_sunny11 + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE='JPN';

  • etechnotraining + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE='JPN';

    You can learn MS SQL and Oracle from the best training institute in bangalore Best Oracle Training Institutes in Bangalore

  • alp075 + 0 comments

    bro who writing these questions, they're not very diverse or challenging

  • jnyh1 + 0 comments

    my solution:

    SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';

  • dashingakd + 0 comments
    SELECT * FROM CITY
    WHERE COUNTRYCODE='JPN';
Load more conversations