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
- Select All
- Discussions
Select All
Select All
Sort by
recency
|
373 Discussions
|
Please Login in order to post a comment
MySQL:
select* from CITY
where COUNTRYCODE='USA' or COUNTRYCODE='NLD';
The question is weirdly formulated. Why is it not just "Query all entry in the table"?
For MySQL
SELECT ID,NAME,COUNTRYCODE,DISTRICT,POPULATION FROM CITY ;
-- MS SQL Server
select * from CITY;