Revising Aggregations - The Count Function

Sort by

recency

|

507 Discussions

|

  • + 0 comments

    SELECT count(*) FROM city WHERE population > 100000 ;

  • + 0 comments

    SELECT COUNT(*) FROM CITY WHERE population >100000;

  • + 0 comments

    SELECT COUNT(*) FROM CITY WHERE Population > 100000;

  • + 0 comments

    select count(COUNTRYCODE) from CITY where POPULATION > 100000;

  • + 0 comments

    SELECT COUNT(*)

    FROM CITY

    WHERE POPULATION > 100000;