Revising the Select Query II

Sort by

recency

|

669 Discussions

|

  • + 0 comments

    SELECT NAME FROM CITY WHERE CountryCode = 'USA' AND 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';

  • + 0 comments

    In this we have to query only name, on condition of POPULATION and COUNTRYCODE.

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

  • + 0 comments

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