Revising the Select Query II

Sort by

recency

|

679 Discussions

|

  • + 0 comments
    SELECT NAME FROM CITY
    WHERE COUNTRYCODE='USA' AND POPULATION >120000
    
  • + 0 comments

    SELECT Name FROM CITY WHERE CountryCode = 'USA' AND Population > 120000 This works!

  • + 1 comment

    SELECT * FROM CITY WHERE POPULATION > 120000 AND CountryCode = 'USA';

    Why is it wrong?

  • + 0 comments

    SELECT NAME FROM CITY WHERE CountryCode = 'USA' AND Population > 120000;

  • + 0 comments

    MySQL

    • Method 1: SELECT Name From City Where CountryCode = 'USA' and Population > 120000;
    • Method 2: SELECT Name From City Where CountryCode = 'USA' && Population > 120000;