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 35 Discussions, By:

votes

  • LD
    ldai100 + 1 comment

    isn't this a repeat of the previous challenge?

    • SS
      shivashettyswat2 + 0 comments

      select * from city where COUNTRYCODE='JPN';

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';

    Feel free to ask if you have any questions :)

  • VM
    muraleeviswanath + 0 comments

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

  • gpratapsingh901 + 0 comments

    select * from city where countrycode='JPN';

  • MA
    finjanah120 + 0 comments

    Solution in MYSQL.

    Select * From CITY where COUNTRYCODE = 'JPN';

  • udiibudii + 0 comments
    select * from city 
where countrycode = 'JPN';

  • priyachevugani + 0 comments

    Solution in MYSQL...select all * from city where countrycode ='JPN';

  • YL
    dai9898 + 0 comments

    who knows the right answer?

  • KT
    kavyakavi556 + 2 comments

    in oracle select *from city where countrycode="jpn"; it was not supported

    • SP
      sureshpatra83 + 0 comments

      SELECT * FROM CITY WHERE COUNTRYCODE='jpn';

    • MM
      mahalakshmimuru1 + 0 comments

      select *from city where countrycode like '%JPN%'

  • SK
    KrishNandu + 0 comments

    If anyone knows kindly revert back

Load more conversations