Some error occured while loading page for you. Please try again.
Sort 40 Discussions, By:
Please Login in order to post a comment
SELECT MAX(Population) - MIN(Population) AS Joke
"AS Joke" xD :V
It is indeed a joke:D
upvoted for extra creativity :)
hahahaha... hilarious :D
Here is Oracle solution from my HackerrankPractice repository:
SELECT MAX(Population) - MIN(Population)
Feel free to ask if you have any questions :)
This solution works for any of the listed RDBMSs:
DB2, mySQL, Oracle, SQL Server.
SELECT MAX(population) - MIN(population)
select max(population) - min(population) from city
select max(population)-min(population) as difference from city;
SELECT MAX(POPULATION)-MIN(POPULATION) FROM CITY;
SELECT max(population) - min(population)
work well for oracle;
select coalesce((max(population)-min(population)),0) from city
SOLUTION IN MYSQL..
SELECT max(population)-min(population) from city;
Solution for Oracle,Mysql,MS Sql Server
SELECT (MAX(POPULATION) - MIN(POPULATION)) FROM CITY;