Revising the Select Query I

Sort by

recency

|

899 Discussions

|

  • + 0 comments

    SELECT*from CITY where COUNTRYCODE='USA' AND POPULATION>100000;

                           (OR)
    

    SELECT*from CITY where COUNTRYCODE='USA' && POPULATION>100000;

  • + 0 comments

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

  • + 1 comment

    SELECT * FROM city WHERE countrycode = 'USA' AND population = 10000;

    i have submited the above query but it is throwing error as wrong answer, please some one help to solve this.

  • + 0 comments
    SELECT *
    FROM CITY
    WHERE CountryCode LIKE '%USA%'
    AND population > 100000
    
  • + 0 comments

    Select * From City Where POPULATION >100000 AND COUNTRYCODE = "USA"