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.
- Prepare
- SQL
- Basic Select
- Japanese Cities' Names
- Discussions
Japanese Cities' Names
Japanese Cities' Names
Sort by
recency
|
409 Discussions
|
Please Login in order to post a comment
SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN';
select name from city where countrycode='JPN';
In this we have to query NAME of all Japanese CITY.
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';
SELECT NAME FROM CITY WHERE COUNTRYCODE="JPN";
A straightforward and useful query! It’s a great example of how SQL can be used to extract specific data from a larger dataset. fairplay24 pro