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 41 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 + 1 comment

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

      I dont why.

      • marinskiy + 0 comments

        Try to check if you selected "Oracle" here:

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

  • mordiana1506 + 0 comments

    select * from CITY where COUNTRYCODE = 'JPN'

  • rayedox + 0 comments

    Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

    select * from city where countrycode='JPN'

    Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

  • jyotipriyaece + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE='JPN';

  • doting_div + 1 comment

    Used the HAVING - LIKE clause and it worked!

    SELECT *

    FROM City

    HAVING Countrycode LIKE 'JPN'

    • abhinavpareek191 + 0 comments

      but why this SELECT * FROM CITY WHERE COUNTRYCODE='JPN'; is not working it will also fetch the same answer

  • muraleeviswanath + 0 comments

    select all * from city where countrycode ='JPN';

  • gpratapsingh901 + 0 comments

    select * from city where countrycode='JPN';

Load more conversations