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 47 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

  • deepaktiwari0821 + 0 comments

    select * from city where countrycode='JPN';

  • coder_aky + 0 comments

    100% Working Simple and easy :-)

    SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';

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

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

    SELECT *
  FROM CITY
 WHERE COUNTRYCODE = 'JPN';

    (From my HackerRank repo on GitHub.)

  • ajeetpatel1024 + 0 comments

    SELECT * FROM city WHERE countrycode= 'jpn';

  • Jitender98 + 0 comments

    MySQL code-

    SELECT * FROM city
WHERE countrycode ='jpn';

  • keerthanagrylls + 0 comments

    what is the meaning of attributes in oracle?

  • meet3698 + 0 comments

    MySQL:

    SELECT * FROM CITY WHERE ID = 1661;

    ORACLE:

    SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';

    MS SQL Server:

    SELECT * FROM CITY WHERE ID = 1661;

Load more conversations