/SQL/The differnece between to values in sql

The differnece between to values in sql

SELECT 	
city,
	year,
      population_needing_house,
      LAG(population_needing_house)
      OVER (PARTITION BY city ORDER BY year ) AS previous_year
      population_needing_house - LAG(population_needing_house)
 	OVER (PARTITION BY city ORDER BY year ) AS difference_previous_year
FROM 	housing
ORDER BY city, year

Source: learnsql.com

Similar codes

2 votes230 views1 answer
Oracle current date without time
SQL
0 vote266 views1 answer
How to change mysql root password in windows 10
SQL
5 votes227 views1 answer
Minecraft java port number
SQL
0 vote223 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote227 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
1 vote227 views1 answer
Mysql stop password policy
SQL
0 vote222 views1 answer
Alasql delete column
SQL
1 vote237 views2 answers
Sql server concat string and int
SQL
0 vote225 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote259 views1 answer
How to make sure two tables have same exact data in sql
SQL