We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Aggregation
  4. Population Density Difference
  5. Discussions

Population Density Difference

Sort 40 Discussions, By:

votes

  • bfdill + 4 comments

    SELECT MAX(Population) - MIN(Population) AS Joke FROM City;

    • akshat7 + 1 comment

      "AS Joke" xD :V

      • SG
        shashank347 + 0 comments

        haha :)

    • FS
      f_safari + 0 comments

      It is indeed a joke:D

    • manuelj + 0 comments

      upvoted for extra creativity :)

    • RS
      ravi122 + 0 comments

      hahahaha... hilarious :D

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT MAX(Population) - MIN(Population)
FROM City;

    Feel free to ask if you have any questions :)

  • pedrokarneiro + 0 comments
    /*
This solution works for any of the listed RDBMSs:
DB2, mySQL, Oracle, SQL Server.
*/

SELECT MAX(population) - MIN(population)
FROM city;

  • PD
    prashantdhiman2 + 0 comments

    select max(population) - min(population) from city

  • DB
    ARIMAdinesh + 0 comments

    select max(population)-min(population) as difference from city;

  • vijay13_sdbce + 0 comments
    SELECT MAX(POPULATION)-MIN(POPULATION) FROM CITY;

  • MK
    ipg_2016051 + 0 comments

    SELECT max(population) - min(population) FROM CITY; work well for oracle;

  • SP
    shankarpentyala + 0 comments

    select coalesce((max(population)-min(population)),0) from city

  • vijayasrisriniv1 + 0 comments

    SOLUTION IN MYSQL..

    SELECT max(population)-min(population) from city;

  • PK
    piyushrao + 0 comments

    Solution for Oracle,Mysql,MS Sql Server

    SELECT (MAX(POPULATION) - MIN(POPULATION)) FROM CITY;

Load more conversations