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

  • lin_jiachao
     + 0 comments

    I'm not sure whether it's asking for distinct names and there's only one test case so I'll just throw this out here:

    SELECT DISTINCT(NAME)
FROM CITY
WHERE COUNTRYCODE = 'JPN';

    btw it works