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.
Population Density Difference
Population Density Difference
+ 0 comments MYSQL SOLUTION Approch 1
SELECT ABS((SELECT POPULATION FROM CITY ORDER BY POPULATION DESC LIMIT 1) - (SELECT POPULATION FROM CITY ORDER BY POPULATION ASC LIMIT 1)) FROM CITY LIMIT 1
Approch 2
SELECT (MAX(POPULATION) - MIN(POPULATION)) FROM CITY;
+ 0 comments MS SQL
SELECT (MAX(POPULATION) - MIN(POPULATION)) AS DIFF_POP FROM CITY;
You don't need brackets on the outside of the aggregate functions.
+ 0 comments SELECT (MAX(POPULATION) - MIN(POPULATION)) FROM CITY;
+ 0 comments SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY
+ 0 comments MySQL
SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY
Load more conversations
Sort 301 Discussions, By:
Please Login in order to post a comment