Revising the Select Query II

Sort by

recency

|

642 Discussions

|

  • + 0 comments

    MySQL:

    select distinct NAME from CITY

    where COUNTRYCODE='USA' and POPULATION>120000

  • + 0 comments

    select NAME from CITY where POPULATION > 120000 AND COUNTRYCODE = 'USA';

  • + 0 comments

    For MySQL

    SELECT name FROM city
    WHERE countrycode = "USA" AND population > 120000;
    
  • + 0 comments

    select NAME from CITY Where CountryCode="USA" and population>120000;

  • + 0 comments

    IN ORACLE

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