- 1,Revising the Select Query I
- Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.
- SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION> 100000;
- 2,Revising the Select Query II
- Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.
- SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION> 120000;
来源: http://www.bubuko.com/infodetail-3127842.html