/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

0 vote251 views1 answer
Add SuperUser MySQL
SQL
0 vote236 views1 answer
Clone table structure mysql
SQL
0 vote250 views1 answer
Mysql shell set time_zone
SQL
0 vote262 views1 answer
Is not sql
SQL
9 votes252 views3 answers
Oracle undo usage by session
SQL
0 vote255 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote268 views1 answer
Drop database using terminal postgres
SQL
0 vote244 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote260 views2 answers
Oracle create tablespace autoextend
SQL
0 vote245 views1 answer
Alasql delete column
SQL