Revising Aggregations - The Sum Function

Sort by

recency

|

450 Discussions

|

  • + 0 comments

    for oracle

    SELECT SUM(population) FROM city WHERE district = 'California';

  • + 0 comments

    SELECT SUM (POPULATION) FROM CITY WHERE DISTRICT = 'California' ;

  • + 0 comments

    For MySQL

    SELECT SUM(population) FROM city
    WHERE district = "california";
    
  • + 0 comments

    select sum(population) from city where district="california";

  • + 0 comments

    For MySQL:

    SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT ='California';