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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Japanese Cities' Names
  5. Discussions

Japanese Cities' Names

Sort by

recency

|

425 Discussions

|

  • kozconsultancy
     + 0 comments

    Query the names of all the Japanese cities in the CITY table.

    BUT we selected name column. why ?

  • sindhuvadithe123
     + 0 comments

    PL/SQL:

    SET SERVEROUTPUT ON;

    BEGIN FOR a IN (SELECT NAME FROM city WHERE countrycode = 'JPN') LOOP DBMS_OUTPUT.PUT_LINE(

            a.name 
    );
END LOOP;

    END; /

    exit;

  • mraghavi009
     + 0 comments

    SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN';

  • arnabbarik63
     + 0 comments

    SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN'

  • SVVBathini_w
     + 0 comments

    For MySQL

    SELECT name FROM city
WHERE countrycode = "JPN";