Revising the Select Query II

Sort by

recency

|

675 Discussions

|

  • + 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;
  • + 0 comments

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

  • + 0 comments

    SELECT NAME FROM CITY WHERE population>120000 AND CountryCode="USA"

  • + 2 comments

    This worked but before this previous question doesn't worked

  • + 0 comments

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